How to select the last record from MySQL table using SQL syntax

Question

I have a table with several records  There is an id field  I would like to select the record with the most recent id  i e  the highest id    Any ideas

User · Answer

You could also do something like this   SELECT tb1   FROM Table tb1 WHERE id    SELECT MAX tb2 id  FROM Table tb2     Its useful when you want to make some joins

User · Answer

SELECT    FROM table name ORDER BY id DESC LIMIT 1

User · Answer

I have used the following two   1 - select id from table name where id    select MAX id  from table name  2 - select id from table name order by id desc limit 0  1

User · Answer

SELECT MAX  field name   AS   primary key   FROM   table name     example   SELECT MAX brand  AS brandid FROM brand tbl

User · Answer

User order by with desc order   select   from t order by id desc limit 1

User · Answer

SELECT   FROM your table ORDER BY id ASC LIMIT 0  1   The ASC will return resultset in ascending order thereby leaving you with the latest or most recent record  The DESC counterpart will do the exact opposite  That is  return the oldest record

User · Answer

SELECT     FROM     table ORDER BY id DESC LIMIT    0  1

[sql] How to select the last record from MySQL table using SQL syntax

Examples related to sql

Examples related to mysql