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

3 votes203 views1 answer
Sql double index
SQL
1 vote231 views1 answer
Ubuntu access database from terminal
SQL
2 votes206 views2 answers
Mysql find max value row
SQL
0 vote205 views1 answer
How we can perform acid Operations in sql with examples
SQL
0 vote214 views1 answer
Mysql min value row
SQL
0 vote273 views1 answer
Sqlite schema structure of a relational database
SQL
0 vote328 views1 answer
Mysql update all record removing 2 hours from column
SQL
4 votes187 views1 answer
Mysql copy table with new name
SQL
0 vote200 views3 answers
Postgres trim string
SQL
0 vote190 views1 answer
Sql server convert date to weekday
SQL