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 votes210 views2 answers
Postgresql search all tables for column name
SQL
0 vote258 views1 answer
R dbConnect(odbc::odbc() to ms sql server remote
SQL
1 vote218 views1 answer
Add multiple row table pl sql
SQL
18 votes201 views6 answers
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
SQL
10 votes210 views2 answers
Oracle alter sequence nextval
SQL
0 vote201 views1 answer
Case insensitive sql
SQL
0 vote198 views1 answer
Mysqli::query(): (HY000/1034): Index for table 'db' is corrupt; try to repair it
SQL
11 votes214 views4 answers
Update row in mysql
SQL
0 vote202 views1 answer
Sql case when exists in another table
SQL
0 vote249 views1 answer
Kimball data warehouse sql calendar
SQL