|
MySQL: Limiting Query Result Number |
|
|
|
Written by Roceller Alvarez
|
|
Saturday, 26 February 2005 |
|
Just a quick tip on how to limit the returned row from a query. This is equivalent to rownum in Oracle.
SELECT * FROM table1
ORDER BY date
LIMIT 10 Only registered users can write comments.
Please login or register. Powered by AkoComment 2.0! |
