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 vote175 views2 answers
Extract weekday from date in sql
SQL
11 votes169 views4 answers
Query DISTINCT
SQL
0 vote135 views1 answer
Mysql workbench search all tables
SQL
7 votes202 views1 answer
Oracle pagination query rownum
SQL
1 vote205 views1 answer
Postgres power
SQL
0 vote176 views1 answer
Sql remove last 2 digit
SQL
16 votes164 views2 answers
Gremove folder from git
SQL
21 votes169 views5 answers
Oracle all tables
SQL
0 vote231 views1 answer
Inner join distinct
SQL
0 vote183 views1 answer
Check for directory in bash
SQL