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 vote135 views1 answer
Rabbitmq service not starting
SQL
0 vote143 views1 answer
Sql select inside select sub query
SQL
3 votes126 views1 answer
Start mysql server linux terminal
SQL
0 vote152 views1 answer
Mysql add text to existing field
SQL
0 vote129 views1 answer
Check sql database table lock
SQL
0 vote123 views2 answers
How to start postgresql laravel
SQL
-1 vote129 views1 answer
Sql getdate date only
SQL
0 vote138 views1 answer
Mssql now diff 90 day
SQL
1 vote133 views3 answers
Getdate function in postgresql
SQL
0 vote132 views1 answer
Product of a column in mysql
SQL