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 vote302 views1 answer
Flask sqlalchemy remove duplicates
SQL
10 votes314 views2 answers
SQL rounding numbers
SQL
0 vote289 views1 answer
Mysql shell set time_zone
SQL
0 vote308 views1 answer
How to know if table in rigt or left in sql
SQL
0 vote292 views1 answer
Mysql read row
SQL
0 vote283 views1 answer
Sql combine results from two tables
SQL
1 vote289 views1 answer
How to get mysql db size
SQL
0 vote315 views1 answer
Stored procedures example
SQL
0 vote305 views1 answer
Get the Domain Name, Page Name and Query Parameter from a URL
SQL
3 votes284 views1 answer
How to remove characters from string in mysql
SQL