/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 vote226 views1 answer
Mysql disable triggers
SQL
27 votes179 views6 answers
Sql update record
SQL
-1 vote144 views1 answer
Search all database tables for a value sqlserver
SQL
1 vote159 views1 answer
Postgresql define pk sequence next number
SQL
0 vote178 views1 answer
Get total and distict row diff in sql
SQL
0 vote158 views1 answer
Mysql update from select on same table
SQL
4 votes102 views1 answer
Generate class from sql table c#
SQL
3 votes147 views2 answers
Oracle grants
SQL
0 vote170 views1 answer
Duplicate value unique constraint mysql error
SQL
0 vote155 views1 answer
Database schema for mcqs type exam in sql
SQL

Share