Is there an alternative to TOP in MySQL?

by

Ordering and limiting the results:

SELECT field1, field2
FROM myTable
ORDER BY field1 ASC
LIMIT 10

More Related Contents:

  1. You can’t specify target table for update in FROM clause
  2. Generating a range of numbers in MySQL
  3. How to get next/previous record in MySQL?
  4. How do I make a row generator in MySQL?
  5. MySQL INSERT INTO table VALUES.. vs INSERT INTO table SET
  6. MySQL number of items within “in clause”
  7. Error 1046 No database Selected, how to resolve?
  8. What’s the difference between VARCHAR and CHAR?
  9. Alter a MySQL column to be AUTO_INCREMENT
  10. Is there something wrong with joins that don’t use the JOIN keyword in SQL or MySQL?
  11. MySQL ON DUPLICATE KEY UPDATE for multiple rows insert in single query
  12. single fixed table with multiple columns vs flexible abstract tables
  13. How many rows in a database are TOO MANY?
  14. Why does this SQL code give error 1066 (Not unique table/alias: ‘user’)?
  15. calculate a sum of type time using sql
  16. Is it possible to have an indexed view in MySQL?
  17. mysql – how many columns is too many?
  18. How exactly does using OR in a MySQL statement differ with/without parentheses?
  19. Best database field type for a URL
  20. Use A Union Or A Join – What Is Faster [closed]
  21. MySQL – how to front pad zip code with “0”?
  22. Find the number of columns in a table
  23. Mysql, reshape data from long / tall to wide
  24. MySQL: Compare differences between two tables
  25. Mysql strip time component from datetime
  26. How do I start auto increment from a specific point?
  27. MySQL SELECT x FROM a WHERE NOT IN ( SELECT x FROM b ) – Unexpected result
  28. MySql bulk load command line tool
  29. ALTER TABLE without locking the table?
  30. MySQL: Typecasting NULL to 0

Leave a Comment