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 vote343 views1 answer
Convert to hexadecimal sql
SQL
0 vote315 views1 answer
Drop column from local database postgres pgadmin
SQL
0 vote330 views1 answer
Oracle running queries
SQL
5 votes330 views1 answer
Sysdate in oracle sql
SQL
0 vote286 views1 answer
Check sql query executed wp
SQL
0 vote297 views1 answer
Remove from table where
SQL
0 vote360 views1 answer
Mysql relationships between tables
SQL
4 votes349 views1 answer
An error occurred while installing pg (1.2.3), and Bundler cannot continue. Make sure that `gem install pg -v '1.2.3' --source 'https://rubygems.org/'` succeeds before bundling.
SQL
13 votes310 views6 answers
Current date sql
SQL
2 votes310 views1 answer
Brew start postgres manual
SQL