/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

1 vote196 views2 answers
Maximum number of tables in mysql
SQL
-1 vote193 views1 answer
How to create foreign key in sql server management studio
SQL
1 vote196 views1 answer
Snowflake rename column name
SQL
1 vote188 views2 answers
Extract weekday from date in sql
SQL
0 vote184 views1 answer
Sql change date format
SQL
0 vote213 views1 answer
Java spring boot connect to sql server
SQL
7 votes179 views3 answers
How to check table name in current database sql
SQL
0 vote201 views1 answer
Tsql table column constraint must be uppercase
SQL
0 vote204 views1 answer
Sql select min row
SQL
4 votes175 views3 answers
Mysql update with join
SQL

Share