/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

2 votes178 views2 answers
Null column to 0 in mysql
SQL
0 vote160 views1 answer
How to remove quotes from a string in ssis load file
SQL
6 votes137 views4 answers
How to remove unique key in mysql
SQL
-1 vote90 views3 answers
Ubuntu install mssql
SQL
7 votes166 views2 answers
Create index mysql cli
SQL
0 vote159 views1 answer
Sqlalchemy query join many to many
SQL
0 vote132 views1 answer
How to connect postgresql database with java
SQL
5 votes151 views1 answer
Oracle list packages
SQL
1 vote141 views1 answer
ERROR 1193 (HY000): Unknown system variable 'GTID_PURGED'
SQL
10 votes141 views2 answers
Mysql alter add foreign key
SQL

Share