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 vote146 views1 answer
Create table with float datatype in sql server
SQL
0 vote132 views1 answer
Postgresql alter column nullable
SQL
1 vote101 views1 answer
Into sql
SQL
1 vote130 views1 answer
Get count by weekly pivot table sql server
SQL
5 votes156 views1 answer
Oracle nls parameters
SQL
-1 vote135 views3 answers
How to restart mysql in linux
SQL
0 vote145 views1 answer
Query only first letter string
SQL
0 vote166 views1 answer
Start stop mysql linux
SQL
-1 vote129 views2 answers
Sql convert date to string yyyy-mm-dd
SQL
3 votes154 views1 answer
Sql datetime as date
SQL