Pagination

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
veeresh
Forum Newbie
Posts: 8
Joined: Sat Jul 26, 2008 1:37 am

Pagination

Post 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:
User avatar
pickle
Briney Mod
Posts: 6445
Joined: Mon Jan 19, 2004 6:11 pm
Location: 53.01N x 112.48W
Contact:

Re: Pagination

Post by pickle »

I've never heard of SQL express. Try Googling for "SQL Express LIMIT clause" or "SQL Express pagination".
Real programmers don't comment their code. If it was hard to write, it should be hard to understand.
veeresh
Forum Newbie
Posts: 8
Joined: Sat Jul 26, 2008 1:37 am

Re: Pagination

Post 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
User avatar
califdon
Jack of Zircons
Posts: 4484
Joined: Thu Nov 09, 2006 8:30 pm
Location: California, USA

Re: Pagination

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