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 vote334 views2 answers
Amazon linux postgresql client
SQL
0 vote324 views1 answer
Wp_query raw sql
SQL
-1 vote266 views1 answer
Mysql if example
SQL
0 vote296 views1 answer
Order by number of character in sql
SQL
0 vote314 views1 answer
Mysql select inside sum
SQL
0 vote302 views4 answers
Database stuck at restoring state
SQL
7 votes351 views2 answers
Sql remove duplicates based on column
SQL
-1 vote297 views1 answer
Django.core.exceptions.ImproperlyConfigured: mysqlclient 1.3.13 or newer is required; you have 0.8.0.
SQL
0 vote303 views1 answer
T-SQL - Where Used List (Table/View)
SQL
1 vote324 views1 answer
Table information in sql server
SQL