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 vote182 views2 answers
Django.core.exceptions.ImproperlyConfigured: mysqlclient 1.4.0 or newer is required; you have 0.10.1.
SQL
0 vote164 views1 answer
Copied text from internet not inserting in mysql
SQL
0 vote156 views1 answer
INSERT INTO table using OpenQuery
SQL
3 votes177 views1 answer
Postgresql today - 1 year
SQL
8 votes179 views2 answers
Sqlsrv default port
SQL
12 votes174 views2 answers
Delete all nodes neo4j
SQL
4 votes230 views4 answers
Check constraint in ms sql
SQL
0 vote168 views1 answer
Formatting code with SQL Developer
SQL
0 vote174 views1 answer
Sql server datetime
SQL
0 vote191 views1 answer
Having all mysql
SQL