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 vote107 views1 answer
Split a string with expression and get the last value of split sql
SQL
0 vote173 views1 answer
Hour differeence in mysql
SQL
0 vote149 views1 answer
Mssql now diff 90 day
SQL
7 votes163 views2 answers
N highest salary in sql
SQL
1 vote164 views1 answer
Mysql limit results to 10
SQL
0 vote158 views1 answer
Postgresql print sessions using the database
SQL
1 vote97 views1 answer
Insert into sql
SQL
0 vote140 views2 answers
How to set global time_zone in mysql
SQL
0 vote163 views1 answer
EnvironmentError: mysql_config not found
SQL
2 votes159 views1 answer
11:04:35 PM [mysql] Error: MySQL shutdown unexpectedly.
SQL