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 vote101 views3 answers
Fetlife
SQL
2 votes97 views1 answer
Oracle cpu per session
SQL
3 votes124 views2 answers
Oracle drop sequence
SQL
1 vote105 views1 answer
Select if then postgresql
SQL
11 votes56 views1 answer
Reset identity sql server
SQL
6 votes106 views1 answer
Postgresql add enum value
SQL
1 vote106 views1 answer
Cannot load driver class: com.mysql.cj.jdbc.Driver
SQL
0 vote100 views1 answer
Composit key in sql
SQL
7 votes109 views4 answers
Index in mysql
SQL
2 votes91 views1 answer
Ifnull postgres
SQL