Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.
Moderator: General Moderators
-
veeresh
- Forum Newbie
- Posts: 8
- Joined: Sat Jul 26, 2008 1:37 am
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
-
pickle
- Briney Mod
- Posts: 6445
- Joined: Mon Jan 19, 2004 6:11 pm
- Location: 53.01N x 112.48W
-
Contact:
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
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
-
califdon
- Jack of Zircons
- Posts: 4484
- Joined: Thu Nov 09, 2006 8:30 pm
- Location: California, USA
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".