/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

1 vote216 views1 answer
Mysql dump specific tables
SQL
1 vote158 views1 answer
Python escape string for sql
SQL
0 vote235 views1 answer
How much space does sql server take per row
SQL
1 vote201 views1 answer
Oracle apex prevent initial load
SQL
1 vote268 views1 answer
Pgsql sum switch case
SQL
5 votes210 views2 answers
Get number of columns sql
SQL
13 votes218 views3 answers
Insert mysql ifile nto database
SQL
0 vote257 views1 answer
Mysql enter ubuntu
SQL
0 vote196 views1 answer
PDOException: SQLSTATE[HY093]: Invalid parameter numb
SQL
2 votes208 views1 answer
Enum in SQL Server
SQL

Share