first LIMIT then ORDER

Is there possibility to first LIMIT and then ORDER records? Using simple query I can first ORDER and then LIMIT like that: SELECT id, name FROM table ORDER BY name LIMIT 20,10 Maybe should I use procedures ? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsu

first LIMIT then ORDER

Is there possibility to first LIMIT and then ORDER records? Using simple query I can first ORDER and then LIMIT like that: SELECT id, name FROM table ORDER BY name LIMIT 20,10 Maybe should I use procedures ? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To un