How to select rows from only the first N rows in a table?

2010-04-27 Thread Peng Yu
It seems that there is no direct support to limit 'select' to only the first N rows in a table. Could you let me know what the best way select rows from the first N rows in a table is? -- Regards, Peng -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

Re: How to select rows from only the first N rows in a table?

2010-04-27 Thread Martijn Tonies
It seems that there is no direct support to limit 'select' to only the first N rows in a table. Could you let me know what the best way select rows from the first N rows in a table is? LIMIT usually works fine ;-) http://dev.mysql.com/doc/refman/5.0/en/select.html With regards, Martijn

Re: How to select rows from only the first N rows in a table?

2010-04-27 Thread Dan Nelson
In the last episode (Apr 27), Martijn Tonies said: It seems that there is no direct support to limit 'select' to only the first N rows in a table. Could you let me know what the best way select rows from the first N rows in a table is? LIMIT usually works fine ;-)

Re: How to select rows from only the first N rows in a table?

2010-04-27 Thread Martijn Tonies
In the last episode (Apr 27), Martijn Tonies said: It seems that there is no direct support to limit 'select' to only the first N rows in a table. Could you let me know what the best way select rows from the first N rows in a table is? LIMIT usually works fine ;-)