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 vote328 views1 answer
Flexible search query delete table
SQL
0 vote294 views1 answer
How to get inserted id in sql server
SQL
1 vote309 views2 answers
Sql multiline comment
SQL
1 vote298 views1 answer
Input in mysql
SQL
0 vote338 views2 answers
How to prevent sql injection in java
SQL
9 votes315 views4 answers
How to create new user and database postgresql in ubuntu
SQL
0 vote338 views1 answer
Find the names of sailors who have reserved at least one boat
SQL
1 vote323 views1 answer
Raise application error in oracle
SQL
1 vote290 views1 answer
Postgresql update auto_increment value
SQL
3 votes334 views1 answer
Locate sql server
SQL