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

0 vote130 views1 answer
Mysql max number not returning correct value
SQL
1 vote120 views1 answer
Sql avg group by
SQL
0 vote140 views1 answer
To_date sql
SQL
0 vote132 views1 answer
Mysql url data type
SQL
3 votes117 views2 answers
Mysql create database
SQL
0 vote113 views1 answer
Job for mysql.service failed because the control process exited with error code.
SQL
0 vote110 views1 answer
Sub blocks in sql
SQL
9 votes173 views6 answers
Replace sql
SQL
1 vote123 views1 answer
How to install mysql 8.0 windows service
SQL
2 votes141 views1 answer
Oracle percentage
SQL