/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 vote249 views1 answer
Get initials name in sql
SQL
9 votes214 views3 answers
Mysql get last id
SQL
1 vote279 views1 answer
Mysql default port
SQL
15 votes234 views6 answers
Drop foreign key mysql
SQL
2 votes235 views2 answers
HOW TO FIND MEDIAN IN SQL FOR BOTH IDD AND EVEN
SQL
0 vote232 views2 answers
How do I UPDATE from a SELECT in SQL Server?
SQL
2 votes267 views1 answer
Oracle run_duration to number
SQL
0 vote213 views1 answer
MySQLdb._exceptions.ProgrammingError: (1146, "Table 'edxapp.app_feedback feedback category' doesn't exist")
SQL
10 votes226 views4 answers
Fetch first 5 characters of the string in sql
SQL
5 votes236 views3 answers
MySql get fields of table
SQL

Share