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 vote193 views1 answer
Soql update query
SQL
57 votes334 views6 answers
Mysql alter table add column
SQL
1 vote207 views1 answer
Increase existing date in sql oracle
SQL
0 vote159 views1 answer
Mysql insert with foreign key
SQL
10 votes213 views1 answer
Oracle view dependencies
SQL
0 vote220 views1 answer
#1231 - Variable 'sql_mode' can't be set to the value of 'NULL'
SQL
1 vote238 views1 answer
Create new table from old table
SQL
4 votes199 views1 answer
Mysql set max connections
SQL
0 vote197 views1 answer
SQL Error 1040 : Too many connections
SQL
7 votes212 views2 answers
Execute mysql file
SQL