/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

3 votes224 views1 answer
Oracle user quota on tablespace
SQL
0 vote193 views3 answers
Get free card roblox
SQL
0 vote181 views1 answer
Mysql group rows with same value
SQL
-1 vote186 views1 answer
Mysql case when multiple conditions
SQL
0 vote240 views1 answer
Count column of tables psql
SQL
1 vote216 views1 answer
Oracle split string
SQL
0 vote202 views1 answer
Is there a way to use read_sql_query and the query has WHERE column = Variable?
SQL
0 vote192 views1 answer
Postgres float to int
SQL
0 vote205 views1 answer
Get date from timestamp in mysql
SQL
0 vote205 views1 answer
Postgres can integer fields be negative
SQL

Share