|
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! |