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)
 fetchind randomly data in sql

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2003-10-10 : 07:58:46
prashant kumar roy writes "i am web developer in emind learning ltd. as a trainee
i want to display records from a table
as there is pagination in site

as i write select statement for a table
it retrieves 12000, records from that table
as in first page i have to show only 25 records
as in second page i have to show next 25 records
as same in every next page till last record of the table
but the problem is in each page query fires , and it gives 12000
records
but i want only 25 records in first page
as in second page only next 25 records
as in the every next page
pls
can u send me the query or the required funda for this


i will be thankful for this

thanks

regds .
prashant kumar roy "

Page47
Master Smack Fu Yak Hacker

2878 Posts

Posted - 2003-10-10 : 08:50:09
http://www.sqlteam.com/item.asp?ItemID=566
http://www.aspfaqs.com/webtech/062899-1.shtml

Jay White
{0}
Go to Top of Page
   

- Advertisement -