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 vote351 views1 answer
Get who is hired in month in sql
SQL
13 votes289 views2 answers
Oracle all source
SQL
0 vote336 views1 answer
Postgre admin slow
SQL
0 vote341 views1 answer
SQL add a totals of differemt rows of the same id
SQL
0 vote361 views1 answer
Select * where id = 1,2,3
SQL
3 votes341 views1 answer
Oracle user quota on tablespace
SQL
0 vote359 views1 answer
Wp_query raw sql
SQL
0 vote380 views1 answer
Can we rollback data that are deleted using DELETE clause?
SQL
4 votes359 views2 answers
Sql server date now
SQL
0 vote371 views1 answer
Postgre query date
SQL