How do I select an entire row which has the largest ID in the table?

by

You could use a subselect:

SELECT row 
FROM table 
WHERE id=(
    SELECT max(id) FROM table
    )

Note that if the value of max(id) is not unique, multiple rows are returned.

If you only want one such row, use @MichaelMior’s answer,

SELECT row from table ORDER BY id DESC LIMIT 1

More Related Contents:

  1. get first occurrence of last changed value of a column [closed]
  2. SQL Print the name of all Employees together with the name of their supervisor
  3. MySQL – Rows to Columns
  4. ROW_NUMBER() in MySQL
  5. multiple query same table but in different columns mysql
  6. How can I make SQL case sensitive string comparison on MySQL?
  7. How can I temporarily disable a foreign key constraint in MySQL?
  8. How to do a batch insert in MySQL
  9. Count the occurrences of DISTINCT values
  10. MySQL offset infinite rows
  11. Ordering by the order of values in a SQL IN() clause
  12. Creating a “Numbers Table” in MySQL
  13. SQL Selecting from two Tables with inner join and limit [duplicate]
  14. SQL: Repeat a result row multiple times, and number the rows
  15. SQL: selecting rows where column value changed from previous row
  16. Why do results from a SQL query not come back in the order I expect?
  17. How to generate data in MySQL?
  18. MySQL combine two columns and add into a new column
  19. Invalid default value for ‘dateAdded’
  20. MySQL error 1241: Operand should contain 1 column(s)
  21. How to set a MySQL row to READ-ONLY?
  22. Split a string and loop through values in MySQL stored procedure
  23. How to create dummy variable columns for thousands of categories in Google BigQuery?
  24. Mysql: Order by like?
  25. Most efficient way to store IP Address in MySQL [duplicate]
  26. Getting first day of the week in MySql using Week No
  27. SQL date format convert? [dd.mm.yy to YYYY-MM-DD]
  28. mysql select id and name from other table and join query
  29. Convert SQL Server query to MySQL [duplicate]
  30. comparison of truncate vs delete in mysql/sqlserver [duplicate]

Leave a Comment