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 vote182 views1 answer
Foreign key in oracle sql developer
SQL
2 votes230 views1 answer
Dbms transaction (psql)
SQL
6 votes234 views2 answers
Psql load dump
SQL
12 votes215 views6 answers
Select distinct
SQL
2 votes218 views3 answers
Row number mssql
SQL
7 votes213 views1 answer
Safe update mysql
SQL
1 vote210 views1 answer
Sql server read uncommitted
SQL
0 vote240 views1 answer
Fetching data from mysqldb
SQL
0 vote222 views1 answer
Mysql enter ubuntu
SQL
0 vote206 views1 answer
Create new schema mysql
SQL