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 vote267 views1 answer
Update mysql centos
SQL
2 votes325 views2 answers
MySql FULL OUTER JOIN
SQL
0 vote265 views1 answer
Intellij idea add mysql connector
SQL
0 vote276 views1 answer
Postgresql list extensions
SQL
3 votes282 views2 answers
@sqlresultsetmapping
SQL
1 vote244 views3 answers
Mariadb add foreign key
SQL
2 votes256 views1 answer
Mysql virtual column
SQL
19 votes266 views5 answers
Mysql between date range
SQL
-1 vote220 views1 answer
Oracle db list usernames
SQL
4 votes255 views1 answer
Postgresql create table with index
SQL