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 vote113 views1 answer
Add column to table with default value plsql
SQL
3 votes109 views2 answers
Oracle synonym
SQL
14 votes138 views3 answers
Oracle sql limit results
SQL
31 votes112 views3 answers
Sql count
SQL
0 vote114 views1 answer
Sql remove decimal places
SQL
2 votes119 views1 answer
How to add where command in update comand with joins
SQL
0 vote132 views1 answer
Sql filter rows with condition
SQL
1 vote165 views1 answer
Difference between where and having clause
SQL
3 votes116 views2 answers
Sql asc
SQL
16 votes126 views4 answers
Mysql import from sql file
SQL