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 votes275 views2 answers
Oracle create table if not exists
SQL
1 vote302 views1 answer
Create email address from first and last name in sql
SQL
2 votes250 views1 answer
Sql get the name of user pc
SQL
0 vote315 views1 answer
Connect google bigquery connect using sqirrel
SQL
1 vote244 views1 answer
Varchar plsql
SQL
6 votes248 views5 answers
Get current date sql
SQL
0 vote249 views1 answer
Sql combine results from two tables
SQL
2 votes273 views1 answer
Oracle to_char number format percentage
SQL
0 vote240 views1 answer
Sql developer format sql
SQL
0 vote275 views2 answers
Replace null with 0 in sql
SQL