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

2 votes289 views2 answers
Postgres select duplicate columns
SQL
16 votes282 views2 answers
Oracle ddl
SQL
2 votes284 views1 answer
Pandas to sql index
SQL
0 vote280 views1 answer
Oracle sql winter time change
SQL
0 vote325 views1 answer
Delete hangfire retries list
SQL
1 vote263 views1 answer
Sql myisam vs innodb
SQL
0 vote296 views3 answers
Database restoring error
SQL
0 vote267 views1 answer
How many columns can be used for creating index?
SQL
1 vote279 views2 answers
Limit sqlserver
SQL
0 vote279 views2 answers
The metadata storage is not up to date, please run the sync-metadata-storage command to fix this issue.
SQL