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 vote182 views1 answer
How to user id to show in from date to upto date in mssql server
SQL
0 vote208 views1 answer
Postgres row expiration
SQL
0 vote175 views1 answer
Ms Sql set us timezone
SQL
0 vote200 views1 answer
Excel vba import data to sql server
SQL
6 votes200 views5 answers
Sql add months to date
SQL
0 vote213 views1 answer
C# get sql min date
SQL
15 votes201 views2 answers
Select Options
SQL
0 vote189 views1 answer
Sql developer format sql
SQL
0 vote205 views1 answer
Psql list rules
SQL
11 votes206 views1 answer
Oracle insert from select
SQL