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 vote311 views1 answer
Mysql auto increment in YY-MM-XXX format
SQL
0 vote324 views2 answers
How to know the character set of an oracle databes
SQL
2 votes310 views1 answer
Sqlite indexes
SQL
2 votes335 views1 answer
Mysql select default if null
SQL
9 votes364 views3 answers
Import DB through mysql console
SQL
4 votes334 views2 answers
Installing sql on ubuntu
SQL
3 votes413 views4 answers
Sql interview questions
SQL
0 vote331 views1 answer
Delete data from database sqlite android
SQL
1 vote375 views1 answer
How to set up a trigger in sql
SQL
0 vote386 views1 answer
Select * from mysql.proc
SQL