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

3 votes340 views2 answers
Brew restart mysql
SQL
1 vote382 views2 answers
Postgresql check privileges on schema
SQL
0 vote332 views1 answer
Mysql grant access to one database
SQL
0 vote287 views1 answer
Finish transaction sql
SQL
7 votes366 views1 answer
Xampp reset mysql
SQL
0 vote336 views2 answers
MySQL top percent
SQL
0 vote348 views2 answers
Psql commande \gset
SQL
0 vote349 views1 answer
With_for_update sqlalchemy
SQL
0 vote344 views1 answer
Alasql delete column
SQL
0 vote310 views1 answer
How to check replication lag in mySQL
SQL