/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

1 vote148 views1 answer
Mysql last year
SQL
0 vote146 views1 answer
Sql count null values in all columns
SQL
7 votes155 views3 answers
Convert ansi sql
SQL
3 votes153 views2 answers
Install mysql powershell
SQL
2 votes134 views2 answers
Compare date mysql
SQL
11 votes265 views2 answers
Import mysql dump command line windows
SQL
0 vote170 views1 answer
Mysqldump: error:
SQL
1 vote161 views1 answer
Psql connect to another database
SQL
5 votes219 views1 answer
Oracle source query
SQL
0 vote148 views2 answers
Plan d'exécution requete oracle autotracer
SQL

Share