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 vote296 views1 answer
Mysql date format unix timestamp
SQL
0 vote315 views1 answer
Querry mysql by 2 columns
SQL
0 vote299 views1 answer
Postgres set default schema
SQL
0 vote251 views1 answer
Now() -1 mysql
SQL
0 vote289 views1 answer
Show create table in postgresql
SQL
7 votes327 views1 answer
Oracle pagination query rownum
SQL
7 votes315 views1 answer
Oracle alter sequence restart start with
SQL
7 votes272 views2 answers
Create index mysql
SQL
4 votes322 views1 answer
Sql select limit range
SQL
0 vote316 views1 answer
Set engine to innodb
SQL