/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 vote133 views1 answer
Postgres convert date to string
SQL
11 votes308 views4 answers
Round in sql
SQL
9 votes128 views3 answers
Sql delete where in
SQL
0 vote139 views1 answer
Typical max-connect-errors mysql
SQL
0 vote135 views2 answers
Temp Space
SQL
29 votes120 views6 answers
Delete all rows from table mysql
SQL
0 vote131 views1 answer
How to set sql_mode for a query in CI model
SQL
0 vote123 views1 answer
Inner joint
SQL
0 vote142 views1 answer
System.Data.SqlClient.SqlException: 'Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.' SqlDataAdapter
SQL
4 votes87 views2 answers
Access to dialectresolutioninfo cannot be null when 'hibernate.dialect' not set
SQL

Share