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

1 vote224 views1 answer
Sql current timestamp
SQL
0 vote247 views1 answer
Find the names of sailors who have reserved at least one boat
SQL
7 votes260 views2 answers
How to create index mysql
SQL
0 vote194 views1 answer
Big query add table rows to another table
SQL
0 vote222 views1 answer
MySQL error code 2068
SQL
0 vote212 views1 answer
Oracle activate program
SQL
1 vote227 views1 answer
Multiple count in sql
SQL
0 vote251 views1 answer
T-sql email validation
SQL
4 votes216 views2 answers
Oracle unliock account
SQL
0 vote250 views1 answer
Oracle session statistics
SQL