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

User · Answer

One can always go for analytical functions as well which will give you more control

select tmp.row from ( select row, rank() over(partition by id order by id desc ) as rnk from table) tmp where tmp.rnk=1

If you face issue with rank() function depending on the type of data then one can choose from row_number() or dense_rank() too.

User · Answer

You could also do  SELECT row FROM table ORDER BY id DESC LIMIT 1    This will sort rows by their ID in descending order and return the first row  This is the same as returning the row with the maximum ID  This of course assumes that id is unique among all rows  Otherwise there could be multiple rows with the maximum value for id and you ll only get one

User · Answer

Try with this    SELECT top 1  id  Col2   row number   over  order by id desc   FROM Table

User · Answer

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

User · Answer

You can not give order by because order by does a  full scan  on a table   The following query is better   SELECT   FROM table WHERE id    SELECT MAX id  FROM table

User · Answer

SELECT    FROM table  WHERE id    SELECT MAX id  FROM TABLE

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

Examples related to mysql

Examples related to sql