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 vote211 views1 answer
Trigger vérifier stock
SQL
0 vote244 views1 answer
SQL-Arten
SQL
7 votes208 views2 answers
Mysql check db size
SQL
0 vote214 views3 answers
Magento 2 order delete from db
SQL
4 votes202 views1 answer
Refresh postgres config
SQL
0 vote252 views1 answer
Ran rails db:migrate and got == 20210620104415 DeviseCreateUsers: migrating ================================ -- create_table(:users) rails aborted! StandardError: An error has occurred, this and all later migrations canceled: SQLite3::SQLE
SQL
0 vote245 views1 answer
How to drop a trigger in postgresql
SQL
21 votes204 views6 answers
Docker run mysql
SQL
0 vote225 views1 answer
Sql script to get a type task on jira datbase for 12 months
SQL
0 vote238 views5 answers
How to make trigger in phpmyadmin
SQL