Return the nth record from MySQL query

by

SELECT * FROM table ORDER BY ID LIMIT n-1,1

It says return one record starting at record n.

More Related Contents:

  1. INSERT INTO SELECT statement with more columns which is not in another table
  2. Why does MYSQL higher LIMIT offset slow the query down?
  3. MySQL load NULL values from CSV data
  4. Hierarchical queries in MySQL
  5. JOIN queries vs multiple queries
  6. Calculate difference between two datetimes in MySQL
  7. What is the maximum length of data I can put in a BLOB column in MySQL?
  8. Why does MySQL allow “group by” queries WITHOUT aggregate functions?
  9. MySql Error 150 – Foreign keys
  10. MySql: MyISAM vs. Inno DB! [closed]
  11. Getting around MySQL “Can’t reopen table” error
  12. Using SQL LIKE and IN together
  13. Retrieve last inserted id with Mysql
  14. How to export data from SQL Server 2005 to MySQL [closed]
  15. MySQL floating point comparison issues
  16. “where 1=1” statement [duplicate]
  17. MySQL How do you INSERT INTO a table with a SELECT subquery returning multiple rows?
  18. How to force case sensitive table names?
  19. MySQL concat() to create column names to be used in a query?
  20. How to delete duplicate records in mysql database?
  21. mysql select sum group by date
  22. Is there a way to get the row number in Mysql like the rownum in oracle [duplicate]
  23. How to get a list of months between two dates in mysql
  24. My SQL Dynamic query execute and get ouput into a variable in stored procedure
  25. MySQL Integer vs DateTime index
  26. Order by FIELD in MYSQL
  27. How to check if field is null or empty in MySQL?
  28. MySQL – Cannot insert NULL value in column, but I have a default value specified?
  29. How to escape apostrophe (a single quote) in MySql?
  30. Working with INTERVAL and CURDATE in MySQL

Leave a Comment