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 vote360 views1 answer
Full outer join in mariadb mysql
SQL
0 vote331 views1 answer
Heavy table in mysql
SQL
0 vote360 views1 answer
Join creating duplicate columns sqllite
SQL
0 vote379 views1 answer
Como saber si tengo mysql instalado
SQL
19 votes358 views6 answers
What is mySQL
SQL
0 vote331 views6 answers
Unique key in sql
SQL
0 vote345 views1 answer
Oracle sql drop table
SQL
22 votes387 views4 answers
Date format mysql
SQL
0 vote344 views1 answer
Oracle sql get value from several rows and concatenate strings
SQL
3 votes542 views6 answers
Sql unique select
SQL