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

2 votes204 views2 answers
Mysql write into table
SQL
1 vote156 views1 answer
Error code 1175 mysql fix
SQL
0 vote205 views1 answer
Mysl like insert a variable
SQL
1 vote187 views2 answers
This month mysql where
SQL
0 vote160 views1 answer
Postgres select except
SQL
0 vote189 views1 answer
Reindex mssql table
SQL
0 vote233 views2 answers
Getting customers with no orders sql
SQL
0 vote165 views1 answer
PostgreSQL types and C# types
SQL
1 vote181 views1 answer
Where to locate set password for mysql
SQL
0 vote158 views1 answer
Mysql import datetime YYYY-MM-DDThh:mm:ss.000000Z
SQL