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 vote273 views1 answer
. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (.Net SqlClient Data Provider)
SQL
1 vote269 views1 answer
Encrypt password postgresql
SQL
5 votes250 views1 answer
Oracle get nls settings
SQL
0 vote304 views1 answer
Postgresql alter table sequence
SQL
1 vote248 views2 answers
Mysql update table from another table
SQL
0 vote254 views1 answer
Postgresql create table with boolean column
SQL
1 vote267 views1 answer
Adding a check statement in sql
SQL
0 vote277 views1 answer
Ajax error exception handeling
SQL
5 votes222 views1 answer
Copy table from one database to another mysql
SQL
6 votes275 views2 answers
Mysql interval 1 day
SQL