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

14 votes413 views5 answers
Set password for postgres user ubuntu
SQL
2 votes378 views4 answers
Mysql get all tables row count
SQL
1 vote391 views1 answer
Database Queries
SQL
0 vote350 views2 answers
Mysql password error create datbase
SQL
37 votes367 views3 answers
Postgresql insert column
SQL
0 vote372 views1 answer
Sql getdate minus 1 day without time
SQL
3 votes354 views1 answer
Sql multi column index performance
SQL
2 votes378 views1 answer
Mariadb json select
SQL
0 vote356 views1 answer
How to create a new shema using query languaage
SQL
2 votes348 views2 answers
Install sqlalchemy
SQL