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

5 votes195 views1 answer
Oracle get nls settings
SQL
0 vote208 views2 answers
Get item by composite primary key mysql
SQL
0 vote220 views1 answer
Sqlite version check
SQL
0 vote218 views1 answer
Java spring boot connect to sql server
SQL
0 vote219 views1 answer
Sqlalchemy case insensitive like
SQL
2 votes177 views1 answer
Oracle create directory
SQL
0 vote251 views1 answer
Ora 00001 error catch plsql
SQL
2 votes238 views3 answers
Sql server reseed identity column
SQL
0 vote251 views3 answers
How to modify alter user root@localhost identified with mysql_native_password by properly
SQL
-1 vote208 views2 answers
Mysql error 1064 you have an error in your sql syntax
SQL