/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

3 votes130 views3 answers
C# sql select
SQL
3 votes125 views1 answer
Postgresql if null then 0
SQL
-1 vote131 views5 answers
Online sql to linq generator
SQL
10 votes129 views1 answer
Query to find object dependencies in oracle
SQL
12 votes132 views2 answers
Delete entries in postgresql
SQL
1 vote135 views1 answer
Mysql select utc time in eastern time
SQL
0 vote137 views1 answer
Insert overwrite table in mysql in nifi
SQL
0 vote134 views1 answer
Sql server remove enter from string
SQL
11 votes311 views4 answers
Round in sql
SQL
1 vote136 views1 answer
Flask sqlalchemy filter multiple conditions
SQL

Share