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 vote201 views1 answer
Sql server alter table column nullable
SQL
0 vote186 views1 answer
Oracle index hint
SQL
1 vote191 views1 answer
T-SQL Alter the column data type
SQL
0 vote196 views1 answer
Count number of entires by months sql
SQL
0 vote195 views2 answers
T SQl Checking Your Username
SQL
0 vote205 views1 answer
Mysql terminal run sql file
SQL
0 vote212 views1 answer
Mysql update from select on same table
SQL
0 vote188 views1 answer
Sql mod even odd
SQL
0 vote258 views1 answer
Split first name and last name in sql
SQL
0 vote189 views1 answer
Sql "List the contact methods found in the Contact table.For each contact method, list how many people chose that contact method."
SQL