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

1 vote345 views1 answer
Oracle create_program
SQL
0 vote323 views1 answer
Which sql statement would you use to remove a view called emp_dept_vu from your schema?
SQL
0 vote353 views1 answer
Prodection ready postgres database step by step
SQL
1 vote364 views1 answer
T-sql find object by name
SQL
3 votes353 views1 answer
Create a table with an id in mysql
SQL
0 vote323 views1 answer
Como hacer un select entre fechas mysql
SQL
0 vote337 views1 answer
Multiple left join mysql
SQL
15 votes328 views2 answers
Select Options
SQL
0 vote411 views1 answer
Jpa generationtype sequence mysql
SQL
4 votes1.1K views1 answer
Oracle show errors
SQL