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 vote163 views1 answer
Command to give readonly access to a postgres sql user
SQL
11 votes132 views1 answer
Oracle insert into where
SQL
21 votes188 views6 answers
Update sql
SQL
0 vote115 views1 answer
How to check oracle index table
SQL
7 votes136 views2 answers
Show size database mysql
SQL
3 votes177 views1 answer
Export postgres database linux
SQL
0 vote139 views1 answer
Spring Flyway Teams Edition or MySQL upgrade required: MySQL 5.5 is no longer supported by Flyway Community Edition, but still supported by Flyway Teams Edition.
SQL
0 vote149 views1 answer
Get first 3 letter of department name in sql
SQL
1 vote164 views2 answers
Remove space in mysql
SQL
27 votes165 views6 answers
Set password mysql
SQL