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

9 votes193 views2 answers
Sql limit order by
SQL
15 votes386 views2 answers
How to sort names in alphabetical order in sql
SQL
-2 votes198 views1 answer
No module named '_sqlite3
SQL
0 vote201 views1 answer
Str_to_date sql server
SQL
0 vote192 views1 answer
Psql check if sql script is valid
SQL
0 vote199 views1 answer
Disable database droping sql
SQL
5 votes186 views3 answers
Truncate function in sql oracle
SQL
0 vote203 views1 answer
Nuget sqllite-net-pcl
SQL
0 vote174 views1 answer
Oracle search columns in schema
SQL
5 votes176 views1 answer
Invalid column name sql
SQL