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 vote136 views1 answer
Sql select most frequent value in column
SQL
0 vote142 views1 answer
Drush run sql select
SQL
0 vote145 views1 answer
Tsql pad left
SQL
1 vote131 views1 answer
Mysql show data from table
SQL
1 vote126 views1 answer
Ilike for date postgres
SQL
7 votes101 views1 answer
Alter table add key sql
SQL
0 vote136 views1 answer
Which lock mode is not available in sql
SQL
0 vote97 views1 answer
Java spring jdbc connect to postgresql
SQL
0 vote183 views1 answer
Regex mongoose
SQL
0 vote138 views1 answer
Create table in dbms cmds
SQL