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 vote150 views1 answer
Create duplicate table postgres
SQL
0 vote183 views1 answer
Flask sqlalchemy decimal
SQL
1 vote208 views1 answer
Oracle index partition
SQL
0 vote192 views1 answer
Tsql pad left
SQL
0 vote252 views1 answer
Sqlite schema structure of a relational database
SQL
7 votes212 views1 answer
Oracle pagination query rownum
SQL
0 vote192 views1 answer
How to create a new db from dumb file mysql
SQL
1 vote188 views3 answers
Reset sql primary key
SQL
9 votes184 views4 answers
How to create new user and database postgresql in ubuntu
SQL
1 vote180 views1 answer
Oracle apex prevent initial load
SQL