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

5 votes342 views1 answer
Postgres integer to serial
SQL
0 vote338 views1 answer
Custom row number
SQL
0 vote379 views1 answer
Sql pivot without aggregate
SQL
0 vote330 views1 answer
Excute raw query
SQL
0 vote325 views1 answer
Mysql show create db
SQL
50 votes415 views6 answers
Sql duplicate rows
SQL
0 vote340 views1 answer
Get from database the most recent data limit by 5
SQL
0 vote331 views1 answer
Export partttion and import in oracle
SQL
0 vote333 views1 answer
Sequelize postgresql schema
SQL
0 vote351 views1 answer
If column value is null then in mysql
SQL