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 vote207 views1 answer
Mysql percentage of total
SQL
1 vote243 views1 answer
Oracle create as select
SQL
0 vote254 views1 answer
Sql query to find percentage of null values in a table
SQL
17 votes230 views3 answers
Postgresql version command
SQL
0 vote233 views1 answer
Exit psql
SQL
8 votes260 views2 answers
Update sql server from another table
SQL
0 vote218 views1 answer
Mysql workbench primary key
SQL
3 votes239 views1 answer
Postgresql if null then 0
SQL
0 vote216 views1 answer
Json_remove mysql
SQL
0 vote203 views1 answer
Mysql find non alphanumeric characters
SQL