/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

5 votes325 views1 answer
Oracle find foreign key dependencies
SQL
0 vote377 views1 answer
Sql ssrs
SQL
1 vote277 views1 answer
Oracle compile schema
SQL
0 vote410 views1 answer
How to get number of months between 2 dates sql server
SQL
1 vote354 views1 answer
How to copy data of a table from another database to table of anaother database
SQL
1 vote331 views3 answers
Psql fatal database does not exist
SQL
0 vote335 views1 answer
Login phpmyadmin without password
SQL
0 vote365 views1 answer
Java sql insert return id
SQL
2 votes336 views6 answers
In operator in sql
SQL
10 votes350 views1 answer
Oracle dba_dependencies
SQL

Share