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 vote189 views3 answers
Divide by zero error in sql
SQL
0 vote174 views1 answer
Isnull in sqlite
SQL
0 vote184 views1 answer
Run mysql xampp shell
SQL
0 vote184 views1 answer
Client does not support authentication protocol requested by server sqlyog
SQL
1 vote164 views2 answers
Rebuild index sql server
SQL
1 vote149 views1 answer
Can we drop a primary key
SQL
9 votes180 views1 answer
Oracle get table schema
SQL
1 vote161 views2 answers
Sql convert datetime to year month
SQL
0 vote153 views1 answer
Mysql find non alphanumeric characters
SQL
0 vote172 views1 answer
Fill up postgres db
SQL