Link to home
Create AccountLog in
Avatar of Rafi_Rafael
Rafi_RafaelFlag for Israel

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
SOLUTION
Avatar of Scott Fell
Scott Fell
Flag of United States of America image

Link to home
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
See answer
SOLUTION
Link to home
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
SOLUTION
Link to home
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
ASKER CERTIFIED SOLUTION
Link to home
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
Avatar of Rafi_Rafael

ASKER

Thank you all