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

10 votes164 views2 answers
Mysql remove only_full_group_by permanently
SQL
0 vote145 views3 answers
Joins and views sql
SQL
0 vote166 views1 answer
Sql use with to get value counts and percentages
SQL
0 vote156 views1 answer
Oracle service name view
SQL
0 vote169 views1 answer
Django mssql backend
SQL
0 vote167 views2 answers
Sql 2 way of select unique
SQL
0 vote151 views2 answers
Postgres default user
SQL
0 vote157 views1 answer
See the structure of a table mysql
SQL
0 vote173 views1 answer
How to get nth number in sql
SQL
2 votes162 views1 answer
Postgresql drop primary key constraint
SQL