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 votes243 views2 answers
Add auto_increment column to existing table mysql
SQL
25 votes208 views4 answers
Metadata
SQL
2 votes229 views1 answer
Postgresql change value in column
SQL
10 votes220 views3 answers
Sql select between two dates
SQL
42 votes246 views6 answers
Sql query duplicate rows
SQL
0 vote175 views1 answer
Bigquery information_schema schema all columns
SQL
0 vote202 views1 answer
Access denied for user 'root'@'localhost' workbench ubuntu
SQL
8 votes231 views1 answer
Sql limit results returned
SQL
4 votes210 views1 answer
What are the data types in sql
SQL
0 vote220 views1 answer
Jenkins SQLCMD run
SQL