/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 vote306 views1 answer
Mysql error codeigniter
SQL
0 vote377 views1 answer
Mysql insert multiple rows based on select
SQL
1 vote345 views2 answers
Postgres cast as decimal
SQL
31 votes326 views3 answers
SQL Server change column data type
SQL
1 vote295 views1 answer
Stored procedure return value
SQL
0 vote327 views1 answer
Sql show all users
SQL
0 vote320 views1 answer
Data types mysql vs postgresql
SQL
0 vote341 views1 answer
How to get nth number in sql
SQL
4 votes332 views2 answers
Linq join
SQL
8 votes321 views1 answer
Show mysql user table
SQL

Share