/SQL/How to get last row of table in sql

How to get last row of table in sql

How to get last row of table in sql

mysql> select *from getLastRecord ORDER BY id DESC LIMIT 1;

5

Source: tutorialspoint.com

Get last record in sql

SELECT * FROM TableName WHERE id=(SELECT max(id) FROM TableName);

5

Source: stackoverflow.com

Select last row in sql

SELECT TOP 1 * FROM Table ORDER BY ID DESC

1

Source: stackoverflow.com

Similar codes

0 vote255 views1 answer
Grant privileges mysql to database 1064
SQL
16 votes239 views3 answers
Order by sql query
SQL
0 vote255 views1 answer
Mysql sql select one day before
SQL
2 votes239 views2 answers
Insert all in sql
SQL
1 vote344 views1 answer
Aqua Data studio postgresql ssl
SQL
0 vote257 views1 answer
Jdbc sql connection string
SQL
1 vote248 views1 answer
Show table columns
SQL
0 vote265 views2 answers
Psql commande \gset
SQL
0 vote323 views1 answer
What is common table expression in sql
SQL
12 votes260 views6 answers
Between in sql
SQL

Share