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 vote181 views1 answer
Sequelize postgresql schema
SQL
1 vote193 views1 answer
Show all event schedular on mysql
SQL
0 vote213 views1 answer
Load utilities in sql server
SQL
0 vote190 views1 answer
Oracle remove line breaks
SQL
7 votes210 views5 answers
Max 3 salary in sql
SQL
0 vote360 views2 answers
Illuminate\Database\QueryExceptionSQLSTATE[HY000] [2002] No such file or directory
SQL
1 vote191 views1 answer
Sql restore backup query
SQL
16 votes190 views4 answers
Ascending order mysql
SQL
0 vote191 views1 answer
Mariadb search columns
SQL
1 vote194 views1 answer
Postgres concat_ws
SQL