/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 vote211 views1 answer
Mysql average of multiple columns
SQL
2 votes184 views3 answers
Mysql unix timestamp to date
SQL
0 vote197 views1 answer
Mysql two joins
SQL
0 vote217 views1 answer
Date 3 months from today sql
SQL
3 votes205 views1 answer
Convert sqlite table to pandas dataframe
SQL
5 votes194 views2 answers
Postgre insert select
SQL
0 vote278 views1 answer
Show all mongodb
SQL
0 vote204 views1 answer
How to delete python anywhere mysql database
SQL
1 vote206 views1 answer
Show table status command in mysql
SQL
2 votes230 views2 answers
Python escape string for sql
SQL

Share