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 vote131 views3 answers
Postgresql allow remote connections
SQL
6 votes121 views3 answers
How to delete table sqlite
SQL
0 vote129 views1 answer
Copying query result to excel
SQL
6 votes112 views5 answers
Get current date sql
SQL
7 votes119 views6 answers
Reset identity column in sql server
SQL
0 vote125 views1 answer
To change the database owner in SQL server
SQL
3 votes123 views1 answer
Postgres kill running query
SQL
-1 vote112 views2 answers
How to select the lowest values from table per client sql
SQL
0 vote136 views1 answer
Regex any word except sql
SQL
24 votes130 views6 answers
Replace mysql
SQL