/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 vote222 views1 answer
Sql new line output
SQL
17 votes275 views6 answers
What is cursor in sql server with example
SQL
22 votes252 views6 answers
Create sql table
SQL
10 votes267 views3 answers
Join multiple tables sql
SQL
0 vote269 views1 answer
Php select data from mysql database without column name
SQL
0 vote251 views1 answer
Oracle sqlp update amount / quantity
SQL
0 vote254 views1 answer
2020 new year
SQL
6 votes258 views2 answers
Join vs union
SQL
0 vote281 views1 answer
Oracle list partitions
SQL
1 vote231 views1 answer
Unique vs distinct sql
SQL

Share