AnsweredAssumed Answered

How to skip set of rows from the table?

Question asked by Rajasekhare on Sep 23, 2017
Latest reply on Sep 28, 2017 by Rajasekhare

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_NAMEDOB
1001Raj30/6/1977
1002Sekhar4/3/2000

 

Table2: CUSTOMER_CONTACT

 

CUSTOMER_ID(FK)CUSTOMER_NAMEPHONE#
1001Raj8877665544
1002Sekhar9988776655

 

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_NAMEDOB
1001Raj30/6/1977
1002Sekhar4/3/2000
1003john6/7/1988
1004tom8/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

Outcomes