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 vote133 views1 answer
Mysql show category once count how many products
SQL
1 vote138 views1 answer
Oracle apex prevent initial load
SQL
7 votes136 views6 answers
Code: 'er_not_supported_auth_mode', errno: 1251, sqlmessage: 'client does not support authentication protocol requested by server; consider upgrading mysql client', sqlstate: '08004', fatal: true
SQL
3 votes144 views2 answers
Check data in table mysql
SQL
1 vote160 views1 answer
Mysql dump specific tables
SQL
22 votes146 views3 answers
SQL CHEATSHEET
SQL
0 vote144 views1 answer
Yesql
SQL
1 vote143 views1 answer
Mysql connect bash
SQL
0 vote163 views1 answer
This week mysql
SQL
0 vote197 views1 answer
TSQL Find csv file in folder
SQL