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

1 vote163 views1 answer
Oracle select first result
SQL
0 vote223 views2 answers
Sql unique
SQL
0 vote283 views1 answer
Como verificar registros duplicados no sql postgresql
SQL
6 votes217 views3 answers
Rename column ORACLE
SQL
8 votes179 views1 answer
Oracle search stored procedures for text
SQL
0 vote212 views1 answer
Change redo log file size in mysql 5.6
SQL
0 vote172 views1 answer
Sqlplus change user
SQL
0 vote166 views1 answer
Events not working db
SQL
22 votes182 views3 answers
Year format in date mysql
SQL
1 vote166 views1 answer
How to remove identity from a column in sql server
SQL