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

1 vote375 views1 answer
How to fetch alternate records from two tables
SQL
2 votes359 views1 answer
How to insert string variable into sqlite database
SQL
1 vote327 views1 answer
Delete triger pl pg sql
SQL
4 votes332 views2 answers
Oracle set date format
SQL
0 vote342 views1 answer
How do i calculate someone's age based on a datetime type birthday?
SQL
0 vote365 views1 answer
Mysql create pool
SQL
0 vote379 views1 answer
Mssql dockere
SQL
1 vote367 views2 answers
Copy database mysql
SQL
1 vote331 views1 answer
Can we drop a primary key
SQL
4 votes346 views1 answer
Oracle error compilation line
SQL