Rafi_Rafael
asked on
how to get rest rows from table
Hello,
i need to get last records from table but without specific rows,
here is what i mean: i have page with 2 <table>
1. in first table i get the top 5 rows
s = "select top 5 * from faq "
closers(rs) : set rs = conn.execute(sqlfilter(s))
2. in the second table i need to get the rest of rows without the first 5 rows from above table,
so what is the sql query?
Thank you
rafi
i need to get last records from table but without specific rows,
here is what i mean: i have page with 2 <table>
1. in first table i get the top 5 rows
s = "select top 5 * from faq "
closers(rs) : set rs = conn.execute(sqlfilter(s))
2. in the second table i need to get the rest of rows without the first 5 rows from above table,
so what is the sql query?
Thank you
rafi
SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
ASKER