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

4 votes330 views1 answer
Search column by name mysql
SQL
0 vote316 views1 answer
Mysql add to value
SQL
9 votes581 views2 answers
Current date in postgresql minus 1 day
SQL
0 vote344 views1 answer
Csv to sqlite python
SQL
0 vote330 views1 answer
Parent: [Error: SQLITE_READONLY: attempt to write a readonly database] {
SQL
0 vote314 views1 answer
Convert sql server guid to varbinary
SQL
0 vote340 views1 answer
Hour differeence in mysql
SQL
0 vote325 views1 answer
Mysql add root password
SQL
7 votes335 views2 answers
Oracle sql drop index
SQL
2 votes345 views1 answer
Mysql set value as null
SQL