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 vote130 views1 answer
Partition by sql server
SQL
0 vote128 views1 answer
[object Object]: BY KimbleOne__DeliveryGroup__c, CreatedDate ^ ERROR at Row:1:Column:142 field 'CreatedDate' can not be grouped in a query call
SQL
0 vote123 views1 answer
Case when with count and combining similar values in sql
SQL
0 vote138 views1 answer
Insert into select with group by
SQL
0 vote132 views1 answer
Delete data from database sqlite android
SQL
1 vote173 views1 answer
Size of all tables in a schema oracle
SQL
18 votes129 views6 answers
Creating table in MySQL
SQL
0 vote123 views2 answers
Postgresql change user role grant
SQL
0 vote191 views1 answer
Import sql dump into postgresql database
SQL
2 votes132 views2 answers
Storing timezones in postgres
SQL