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 vote195 views1 answer
Postgres : ERROR: division by zero
SQL
1 vote188 views3 answers
Getdate function in postgresql
SQL
-1 vote333 views1 answer
Brisanje dupliranih konatakata
SQL
1 vote214 views1 answer
Mysql not supported auth mode
SQL
0 vote214 views1 answer
Disable database droping sql
SQL
1 vote200 views2 answers
Postgresql list columns
SQL
0 vote195 views1 answer
Mysql identified by syntax error
SQL
0 vote240 views1 answer
Mysql récupérer le code création de vue
SQL
4 votes222 views1 answer
Sql query to make a existing column auto increment
SQL
4 votes289 views2 answers
Mysql alter table set column unique
SQL