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 vote239 views3 answers
Showing all columns in an sqlite table
SQL
1 vote233 views2 answers
Sql left characters
SQL
0 vote221 views1 answer
Postgresql copy backup table
SQL
0 vote224 views1 answer
Oracle execute package dblink
SQL
1 vote248 views1 answer
Cannot drop database because it is currently in use
SQL
11 votes224 views2 answers
Sql rank
SQL
0 vote247 views3 answers
Sql query checker
SQL
7 votes248 views1 answer
Mysql remote connection command line
SQL
4 votes247 views1 answer
Mysql ip address data type
SQL
0 vote228 views1 answer
Mql5 datetime get hour
SQL