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

2 votes119 views1 answer
Query any digits record
SQL
0 vote110 views1 answer
How to connect sqlalchemy to mysql and deploy it
SQL
3 votes143 views3 answers
List columns in table postgres
SQL
0 vote153 views1 answer
How to get column name in db from an sqlalchemy attribute model
SQL
0 vote104 views1 answer
Pl sql join 3 tables
SQL
0 vote101 views1 answer
Alter table fulltext
SQL
14 votes106 views3 answers
How to add default constraint in mysql
SQL
1 vote117 views2 answers
Reset mysqli fetch_arra
SQL
0 vote92 views1 answer
Java spring boot connect to sql server
SQL
0 vote112 views1 answer
Ubuntu stop mysql from starting on boot
SQL