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
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".