How can I select the row with the highest ID in MySQL

Question

How can I select the row with the highest ID in MySQL  This is my current code   SELECT   FROM permlog WHERE max id    Errors come up  can someone help me

User · Answer

SELECT   FROM permlog WHERE id     SELECT MAX id  FROM permlog       This would return all rows with highest id  in case id column is not constrained to be unique

User · Answer

SELECT MAX ID  FROM tablename LIMIT 1   Use this query to find the highest ID in the MySQL table

User · Answer

SELECT MAX id   FROM  TABELNAME   This identifies the largest id and returns the value

User · Answer

For MySQL   SELECT   FROM permlog ORDER BY id DESC LIMIT 1   You want to sort the rows from highest to lowest id  hence the ORDER BY id DESC  Then you just want the first one so LIMIT 1      The LIMIT clause can be used to constrain the number of rows returned by the SELECT statement            With one argument  the value specifies the number of rows to return from the beginning of the result set

User · Answer

if it s just the highest ID you want  and ID is unique auto increment   SELECT MAX ID  FROM tablename

User · Answer

Suppose you have mulitple record for same date or leave type but different id and you want the maximum no of id for same date or leave type as i also sucked with this issue   so Yes you can do it with the following query   select   from tabel name where employee no  123  and id      select max id  from table name where employee no  123  and leave type  5

User · Answer

SELECT   FROM  permlog  as one RIGHT JOIN  SELECT MAX id  as max id FROM  permlog   as two  ON one id   two max id

User · Answer

This is the only proposed method who actually selects the whole row  not only the max id  field  It uses a subquery  SELECT   FROM  permlog WHERE id     SELECT MAX  id   FROM permlog

User · Answer

SELECT   FROM permlog ORDER BY id DESC LIMIT 0  1

[mysql] How can I select the row with the highest ID in MySQL?

Examples related to mysql