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

1 vote345 views1 answer
Postgres concat_ws
SQL
0 vote403 views2 answers
How to truncate all table in mysql workbench
SQL
13 votes367 views2 answers
Sql online compiler
SQL
0 vote300 views1 answer
Mitigation of sql injection
SQL
0 vote354 views1 answer
Sql decode
SQL
1 vote358 views1 answer
Order by oracle
SQL
0 vote360 views1 answer
Leftjoin in sql
SQL
0 vote406 views1 answer
Insert using condition postgres
SQL
25 votes436 views4 answers
Import mysql dump command line
SQL
0 vote364 views1 answer
Less mysql display
SQL