Hi Team,
I want to skip few rows while retrieving the data from the table.
Ex: I am publishing the data into below two tables.
Table1: CUSTOMER
CUSTOMER_ID(PK) | CUSTOMER_NAME | DOB |
---|
1001 | Raj | 30/6/1977 |
1002 | Sekhar | 4/3/2000 |
| | |
Table2: CUSTOMER_CONTACT
CUSTOMER_ID(FK) | CUSTOMER_NAME | PHONE# |
---|
1001 | Raj | 8877665544 |
1002 | Sekhar | 9988776655 |
| | |
First i have inserted 2 rows in CUSTOMER table and Inserted the 2 rows in CUSTOMER_CONTACT Table by retrieving teh data from CUSTOMER table using below function.
@seqlov(0,@sqllist(S,SELECT CUSTOMER_ID FROM CUSTOMER)@)@
--> Now i have inserted 2 more rows in CUSTOMER Table as below.
Table1: CUSTOMER
CUSTOMER_ID(PK) | CUSTOMER_NAME | DOB |
---|
1001 | Raj | 30/6/1977 |
1002 | Sekhar | 4/3/2000 |
1003 | john | 6/7/1988 |
1004 | tom | 8/9/1999 |
Now i want publish two more rows in CUSTOMER_CONTACT Table for teh two new rows in CUSTOMER table.
How to skip first 2 rows while retrieving the data from teh customer table.
Please suggest me how can i proceed.
Thanks,
Rajasekhar