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 votes186 views1 answer
Date conversion in mysql column
SQL
0 vote176 views1 answer
Uninstall mysql ubuntu 18.04 stackoverflow
SQL
0 vote195 views1 answer
Sql query to get contact form 7 fields
SQL
2 votes216 views1 answer
Sql count having
SQL
0 vote165 views1 answer
Jooq finding lastest value in table
SQL
1 vote211 views3 answers
Sql procedure
SQL
0 vote174 views2 answers
Add new column after in sql
SQL
1 vote188 views1 answer
Convert epoch to date in sql server
SQL
12 votes217 views6 answers
Distinct in sql server
SQL
22 votes192 views6 answers
Create sql table
SQL