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

6 votes235 views2 answers
Spring data jpa application.properties mysql
SQL
0 vote243 views1 answer
Create duplicate table in postgresql
SQL
1 vote274 views1 answer
Oracle avg
SQL
1 vote271 views1 answer
Timestamp in sqlite
SQL
0 vote278 views1 answer
Python connect microsoft sql server
SQL
0 vote265 views1 answer
Not between mysql
SQL
0 vote289 views2 answers
Postgresql gset
SQL
0 vote280 views3 answers
Create and attach user to a postgresql database
SQL
11 votes292 views2 answers
Oracle source code
SQL
0 vote268 views1 answer
Horizontal join sqlite
SQL