/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 vote294 views1 answer
How to to get current date in sql
SQL
0 vote280 views1 answer
SQL get max per id
SQL
0 vote316 views1 answer
Vbscript connect mssql
SQL
0 vote285 views1 answer
Sql datediff month
SQL
0 vote321 views1 answer
Sql query to find percentage of null values in a table
SQL
0 vote294 views1 answer
Mssql view column data type
SQL
1 vote292 views1 answer
Mysql view command
SQL
1 vote351 views1 answer
Sql random sampling per group
SQL
0 vote292 views1 answer
Update database collation in postgresql
SQL
0 vote306 views1 answer
Find duplicate users by email address in mysql
SQL

Share