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 vote149 views1 answer
Sql server insert into temp table
SQL
4 votes141 views1 answer
Mysql not equal
SQL
0 vote141 views1 answer
Mod function example
SQL
0 vote142 views1 answer
Char vs varchar2 in sql
SQL
3 votes138 views2 answers
Mysql time
SQL
1 vote123 views1 answer
Tsql update datetime
SQL
11 votes145 views2 answers
Turn off safe mode mysql
SQL
0 vote138 views1 answer
Oracle last connection
SQL
0 vote151 views1 answer
Test database for sql
SQL
0 vote159 views2 answers
How to list all values of a column that start with a letter in sql
SQL