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 vote178 views1 answer
Sql query tags
SQL
1 vote142 views3 answers
How to filter repeated same result using sql query
SQL
0 vote145 views1 answer
Query on date sqlite flutter
SQL
0 vote160 views1 answer
Oracle sql copy table without data
SQL
3 votes187 views2 answers
Find string in stored procedure sql server
SQL
0 vote143 views1 answer
SQL Server format datetime
SQL
19 votes165 views6 answers
Mysql if null
SQL
0 vote155 views2 answers
Sql use not in
SQL
1 vote154 views2 answers
Pad zero sql server
SQL
0 vote163 views2 answers
Postgresql variable in query
SQL