Sql select last id

SELECT
  (SELECT * FROM tableName ORDER BY col1 LIMIT 1)        AS first,
  (SELECT * FROM tableName ORDER BY col1 DESC LIMIT 1)   AS last
;

Source: stackoverflow.com

Sql select last id

#Where the the column name is "ID" and table name is "tablename" and ID naming is increasing numerical value.
SELECT * 
FROM tablename
WHERE ID = (
    SELECT MAX(ID) 
  	FROM Table)

Sql get last ID

SELECT MAX(id) FROM <tablename>

Similar codes

0 vote115 views3 answers
Sql count condition
SQL
3 votes118 views3 answers
Sql last week
SQL
1 vote108 views1 answer
Apex run 404
SQL
0 vote109 views2 answers
Sql last updated
SQL
0 vote122 views1 answer
Using GROUP BY in MySQL Join Table
SQL
1 vote107 views1 answer
Cross schema query oracle 2 users
SQL
1 vote99 views1 answer
Oracle user last connected
SQL
0 vote127 views2 answers
How do I UPDATE from a SELECT in SQL Server?
SQL
0 vote79 views1 answer
Raven ql select count
SQL
12 votes120 views1 answer
Docker mysql random root password
SQL