/SQL/Select latest entry in sql table

Select latest entry in sql table

How to get last row of table in sql

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

5

Source: tutorialspoint.com

Get latest record in sql

ex:
SELECT TOP 1 * FROM [TABLENAME] ORDER BY id DESC

2

Select latest entry in sql table

SELECT TOP 1 * FROM Table ORDER BY ID DESC

0

Source: stackoverflow.com

Similar codes

0 vote292 views1 answer
Get who is hired in february in sql
SQL
2 votes269 views6 answers
In in sql
SQL
4 votes283 views2 answers
Oracle unlock user
SQL
0 vote278 views1 answer
Mysql utc timestamp
SQL
0 vote263 views1 answer
Sql count null as 0
SQL
15 votes291 views4 answers
Export mysql db using command line
SQL
6 votes290 views2 answers
If not exists insert sql
SQL
0 vote263 views1 answer
Oracle drop default value
SQL
2 votes284 views4 answers
Sql query interview questions
SQL
0 vote273 views2 answers
How to update the multiple rows in sql
SQL

Share