/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 vote150 views1 answer
My sql data file extention
SQL
0 vote139 views1 answer
Syntax for changing column size in mysql
SQL
0 vote153 views1 answer
Postgresql create query
SQL
0 vote144 views1 answer
C# mysql update statement set value to null
SQL
0 vote157 views1 answer
Create dump file mysql workbench
SQL
2 votes146 views3 answers
How to check current user in mySQL
SQL
0 vote165 views1 answer
Tablas bootstrap responsive sql server para datos vivos
SQL
2 votes204 views1 answer
Flask sqlalchemy boolean field
SQL
0 vote161 views1 answer
Docker open terminal mysql server
SQL
0 vote149 views1 answer
Error: connect ECONNREFUSED 127.0.0.1:5432 at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1148:16
SQL

Share