/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

10 votes113 views4 answers
Else if mysql
SQL
0 vote93 views1 answer
How to find symmetric pairs in sql
SQL
5 votes100 views1 answer
JBDC
SQL
0 vote107 views1 answer
EnvironmentError: mysql_config not found
SQL
-1 vote94 views1 answer
Add column alter table default value
SQL
0 vote102 views1 answer
Sql get user account
SQL
0 vote100 views1 answer
Get number of rows in every table mysql
SQL
0 vote105 views1 answer
Join in update query in mysql
SQL
8 votes108 views2 answers
Alert table name mysql
SQL
0 vote112 views1 answer
Get the Db column names from a SqlDataReader
SQL

Share