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 vote172 views1 answer
Mysql select distinct date from timestamp
SQL
0 vote183 views1 answer
Sql server for loop
SQL
1 vote183 views1 answer
Psql view enum values
SQL
2 votes188 views1 answer
SQL column name Postgre
SQL
0 vote156 views1 answer
Full syntax inner join
SQL
0 vote187 views2 answers
Reseed sql identity
SQL
0 vote152 views3 answers
Mysql calculate age from date of birth
SQL
0 vote206 views1 answer
Sqlite3 not commit
SQL
3 votes165 views1 answer
Oracle user quota unlimited
SQL
2 votes207 views3 answers
Current setting postgres timezone
SQL