Sql get last inserted row

How to get last row of table in sql

mysql> select *from getLastRecord ORDER BY id DESC LIMIT 1;

Source: tutorialspoint.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 inserted row

select * from table where ID = (SELECT @@IDENTITY)

Similar codes

12 votes176 views4 answers
Mysql ifnull
SQL
0 vote183 views1 answer
With_for_update sqlalchemy
SQL
2 votes268 views1 answer
Db.relationship sqlalchemy flask
SQL
0 vote237 views1 answer
Prisma transaction
SQL
1 vote186 views2 answers
Sql where keyword
SQL
0 vote211 views1 answer
Transalations from sql to Linq count and group by
SQL
3 votes230 views1 answer
Delete all content in table mysql
SQL
2 votes216 views1 answer
Select from array in psql
SQL
0 vote227 views2 answers
How to install psql in ubuntu
SQL
-2 votes252 views1 answer
Mysql not empty
SQL