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 vote268 views2 answers
Insert into
SQL
0 vote290 views1 answer
Create a plsql object
SQL
0 vote266 views1 answer
Get records in sql according to month name and count
SQL
0 vote275 views1 answer
Mysql workbench view
SQL
0 vote275 views1 answer
Set classpath for mysql-connector.jar
SQL
1 vote251 views1 answer
Postgres get timestamp
SQL
0 vote270 views1 answer
Parent: [Error: SQLITE_READONLY: attempt to write a readonly database] {
SQL
0 vote263 views1 answer
Sql query to select records entered in last 24 hours
SQL
1 vote273 views1 answer
Deleting database in sql
SQL
0 vote275 views1 answer
Mysql join only one column
SQL