Page 1 of 1

Pagination

Posted: Fri Aug 15, 2008 6:43 am
by veeresh

HI


I am working on odbc queries, Any one tell me how to select number of rows per page

In mysql it is LIMIT($offset, $limit); using this we display, what about in sql express!

I have 4 tables tables join and union operation i used

select top 10 * is for num of rows per page . if we click next how to write query

i have to display 1-20 ,20-40, 40-60 ------- not using any coumn name in query

:crazy:

Re: Pagination

Posted: Fri Aug 15, 2008 9:56 am
by pickle
I've never heard of SQL express. Try Googling for "SQL Express LIMIT clause" or "SQL Express pagination".

Re: Pagination

Posted: Sat Aug 16, 2008 1:22 am
by veeresh
Thanks for your suggesion I got on query which will acts same like
LIMIT(offset,limit)

SELECT * FROM ( SELECT *, ROW_NUMBER() OVER (ORDER BY login_id)
as row FROM tbl_login ) a WHERE row > 5 and row <= 10


Thanks

Re: Pagination

Posted: Sat Aug 16, 2008 11:09 pm
by califdon
pickle wrote:I've never heard of SQL express. Try Googling for "SQL Express LIMIT clause" or "SQL Express pagination".
Microsoft now calls its free version of SQL Server, "Express".