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 vote147 views1 answer
Mysql max number not returning correct value
SQL
1 vote160 views1 answer
Oracle index partition
SQL
4 votes163 views2 answers
Delete all table oracle
SQL
9 votes142 views3 answers
Mysql show table column full description
SQL
0 vote184 views1 answer
Stop psql server windows
SQL
0 vote142 views1 answer
Insert data from stored procedure into table
SQL
0 vote146 views1 answer
Subquery aggregation
SQL
0 vote154 views1 answer
Sql list dates between two dates
SQL
5 votes161 views4 answers
Start postgres server
SQL
2 votes147 views1 answer
How to make insert script from table in SQL server
SQL