/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 votes208 views1 answer
Sql calculate working days between two dates excluding weekends and holidays
SQL
0 vote203 views4 answers
User defined function sql
SQL
1 vote241 views1 answer
Mysql show long running queries
SQL
4 votes200 views1 answer
Mysql biginteger size
SQL
1 vote186 views3 answers
How to truncate foreign key constraint table
SQL
65 votes568 views6 answers
Sql add column to table
SQL
1 vote242 views3 answers
Nth highest salary
SQL
8 votes219 views1 answer
Alter tablespace add datafile autoextend
SQL
0 vote189 views2 answers
Postgres default user
SQL
15 votes250 views5 answers
Show tables in oracle
SQL

Share