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 vote301 views1 answer
Sql commands in android
SQL
0 vote307 views1 answer
Date datatype in livesql
SQL
0 vote246 views1 answer
Select mysql limit to 2 decimal places
SQL
0 vote265 views1 answer
How to update rows from a table when certain conditions are met in mysql
SQL
0 vote311 views1 answer
Move table to a different schema
SQL
0 vote242 views2 answers
Https://www.google.com/search?ei=bihqX_v9DJb--gTYoLH4DQ
SQL
7 votes288 views3 answers
Select latest entry in sql table
SQL
1 vote422 views3 answers
Uninstall postgresql mac
SQL
19 votes283 views2 answers
Mysql add column after another
SQL
1 vote271 views1 answer
Nested if in mysql
SQL