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 vote238 views1 answer
How to select a row in sql
SQL
2 votes227 views2 answers
Install sqlalchemy
SQL
8 votes245 views4 answers
How to calculate the age from date of birth in python
SQL
1 vote248 views1 answer
Raise application error in oracle
SQL
0 vote240 views1 answer
How to login to mysql in homestead
SQL
0 vote234 views1 answer
Get number of tables in database sql
SQL
0 vote238 views2 answers
Sql use not in
SQL
0 vote220 views1 answer
Mysql events not work
SQL
0 vote243 views1 answer
Execute sql stored procedure in powershell
SQL
0 vote236 views1 answer
Online sql testing tool
SQL