Is there a way to get the row number in Mysql like the rownum in oracle [duplicate]

by

Until MySQL finally supports modern SQL, the only way to get something similar is this: 

SELECT @rownum:=@rownum + 1 as row_number, 
       t.*
FROM ( 
   < your original query goes here >
) t,
(SELECT @rownum := 0) r

More Related Contents:

  1. In SQL Server how to get the count of child if both parent and child are available [closed]
  2. How to select the nth row in a SQL database table?
  3. SQL: Repeat a result row multiple times, and number the rows
  4. How do I decide when to use right joins/left joins or inner joins Or how to determine which table is on which side?
  5. Does mysql have the equivalent of Oracle’s “analytic functions”?
  6. Use Composite Primary Key as Foreign Key
  7. What does SQL Select symbol || mean?
  8. MySQL equivalent of Oracle’s SEQUENCE.NEXTVAL
  9. Why in SQL NULL can’t match with NULL?
  10. INSERT INTO SELECT statement with more columns which is not in another table
  11. MySQL how to fill missing dates in range?
  12. ‘IF’ in ‘SELECT’ statement – choose output value based on column values
  13. How to split the name string in mysql?
  14. Why does MySQL allow “group by” queries WITHOUT aggregate functions?
  15. How to set a maximum execution time for a mysql query?
  16. SQL keys, MUL vs PRI vs UNI
  17. How to copy a row and insert in same table with a autoincrement field in MySQL?
  18. How to move columns in a MySQL table?
  19. Using group by on two fields and count in SQL
  20. Can MySQL convert a stored UTC time to local timezone?
  21. Whats the fastest way to lookup big tables for points within radius MySQL (latitude longitude)
  22. MySQL CONCAT returns NULL if any field contain NULL
  23. Does Order of Fields of Multi-Column Index in MySQL Matter
  24. Alternative to using LIMIT keyword in a SubQuery in MYSQL
  25. How to get a list of months between two dates in mysql
  26. My SQL Dynamic query execute and get ouput into a variable in stored procedure
  27. Postgres LEFT JOIN with WHERE condition
  28. How to check if field is null or empty in MySQL?
  29. MySQL OPTIMIZE all tables?
  30. Deleting a row based on the max value

Leave a Comment