Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 How to show next 25 records from SELECT query

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-07-19 : 12:56:50
shyam writes "Hi,

suppose there are 25 records in "customer_Table" table.
when i use "SELECT TOP 5 * FROM customer_Table ORDER BY cust_No" , it shows first 5 records in result set.
when i again run the above QUERY i want next 5 records in the result set.

How can do that?

Regards
SHYAM MORE"
   

- Advertisement -