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 vote126 views1 answer
Distance calculator from lat long sql query
SQL
0 vote102 views1 answer
How to get employee having maximum experience in mysql
SQL
0 vote126 views2 answers
Greater than sql server
SQL
1 vote107 views1 answer
Nested if in mysql
SQL
3 votes106 views1 answer
Oracle wait
SQL
11 votes122 views1 answer
Ddl view
SQL
1 vote114 views1 answer
Pl sql ptint
SQL
2 votes109 views3 answers
Postgres remove foreign key constraint
SQL
10 votes142 views4 answers
Fetch first 5 characters of the string in sql
SQL
0 vote127 views1 answer
Helptext in sql
SQL