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 vote158 views1 answer
Age postgres
SQL
0 vote145 views1 answer
Mysql user set plugin
SQL
0 vote144 views1 answer
Postgres select except
SQL
0 vote158 views1 answer
Couldn't execute 'SELECT COLUMN_NAME
SQL
0 vote164 views2 answers
How to get the date from datetime in mysql
SQL
4 votes184 views3 answers
Postgres drop all tables
SQL
7 votes161 views3 answers
Python and mysql connectivity
SQL
8 votes153 views6 answers
Sql insert
SQL
0 vote139 views1 answer
Drop all tables in azure sql database
SQL
1 vote277 views2 answers
Postgres select from last 3 months
SQL