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

9 votes205 views3 answers
Mysql run sql file
SQL
0 vote195 views1 answer
Drop view in mysql
SQL
10 votes190 views4 answers
SELECT FROM WHERE
SQL
2 votes179 views4 answers
Duplicate record mysql
SQL
-1 vote171 views1 answer
How to format tables in sqlplus
SQL
0 vote196 views1 answer
Alter rename command in mysql
SQL
1 vote179 views4 answers
Sequelize migration default value
SQL
0 vote258 views1 answer
How to check event scheduler status mysql
SQL
0 vote189 views1 answer
Caused by: java.lang.RuntimeException: Unable to obtain credentials to communicate with the Cloud SQL API
SQL
2 votes228 views1 answer
Oracle current date without time
SQL