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

4 votes170 views1 answer
Sql any
SQL
13 votes177 views3 answers
Sql select from multiple tables without join
SQL
0 vote194 views1 answer
Sql multiple into
SQL
1 vote176 views1 answer
Sql bitwise operators
SQL
0 vote174 views1 answer
Heidisql check how much space a row
SQL
8 votes182 views5 answers
Grant permission in postgres
SQL
4 votes179 views1 answer
Create column mysql terminal
SQL
0 vote175 views1 answer
SQL authentication error
SQL
0 vote184 views1 answer
Where name ends in SQL
SQL
0 vote197 views4 answers
Creating a comment and reply system PHP and MySQL
SQL