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 vote213 views1 answer
Supprimer les valeur d'une table mysql
SQL
1 vote197 views1 answer
Mysql list bigger table
SQL
4 votes235 views2 answers
Insert current date in mysql
SQL
2 votes182 views2 answers
Oracle create table if not exists
SQL
0 vote194 views1 answer
Sql include rows with 0 values
SQL
1 vote193 views1 answer
What is in condition in sql
SQL
0 vote184 views1 answer
Top frequency in sql server
SQL
0 vote191 views1 answer
Sql add calculated column
SQL
0 vote195 views1 answer
Mysql date only no time
SQL
0 vote405 views1 answer
Redirection 301 htaccess nom de domaine
SQL