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

Question

How would I do something like this?

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

Answer 1

You can use the subselect like this:

SELECT row 

FROM table 

WHERE id=(

    SELECT max(id) FROM table

    )

Note: If the value of max(id) is not unique, multiple rows will be returned. But, if you only want one such row then use this:

SELECT row from table ORDER BY id DESC LIMIT 1