Forums Register Login

Query limit rows in database

+Pie Number of slices to send: Send
[mysql]
select * from XXXtable limit [offset,] rows
[oracle]
select * from XXXtable where rownum < rowindex
[sqlserver]
select * top rows from XXXtable
In my opinion,mysql is the best at this function!
+Pie Number of slices to send: Send
OR in java for all three databases:

In my opinion, this is the best way so you're not finding/changing all your queries when you change databases!
Jamie
+Pie Number of slices to send: Send
You are a good Man.Thanks.
Slideshow boring ... losing consciousness ... just gonna take a quick nap on this tiny ad ...
a bit of art, as a gift, that will fit in a stocking
https://gardener-gift.com


reply
reply
This thread has been viewed 2150 times.
Similar Threads
Suggest me a best way to do this
Show retrived rows while fetching from database
how to select 2nd,3rd or the Nth highest salary from a table in desc or ascen order?
getting a range of returned rows?
SQL Server limiting result set
More...

All times above are in ranch (not your local) time.
The current ranch time is
Mar 28, 2024 19:29:02.