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

2 votes131 views2 answers
How to get the date diff of 2 dates in the same fieldin sql server
SQL
11 votes143 views2 answers
How to import mysql database command line
SQL
2 votes152 views2 answers
Mysql add hours to time field
SQL
6 votes137 views3 answers
Check if string contains substring sql
SQL
0 vote231 views1 answer
Mysql select field if condition
SQL
4 votes140 views2 answers
Delete all table oracle
SQL
-1 vote132 views3 answers
SQL to LINQ converter
SQL
1 vote150 views2 answers
Mysql error 1215
SQL
0 vote138 views1 answer
Use mysql in java program
SQL
11 votes133 views1 answer
Mysql text type max length
SQL