/SQL/How to get last row of table in sql

How to get last row of table in sql

How to get last row of table in sql

mysql> select *from getLastRecord ORDER BY id DESC LIMIT 1;

5

Source: tutorialspoint.com

Get last record in sql

SELECT * FROM TableName WHERE id=(SELECT max(id) FROM TableName);

5

Source: stackoverflow.com

Select last row in sql

SELECT TOP 1 * FROM Table ORDER BY ID DESC

1

Source: stackoverflow.com

Similar codes

18 votes179 views6 answers
Drop table if exists
SQL
0 vote182 views1 answer
Two inner joins sql
SQL
0 vote174 views1 answer
SQL Server format datetime
SQL
0 vote172 views1 answer
Default value false mysql
SQL
0 vote200 views1 answer
How to select only a certain date sql
SQL
0 vote187 views2 answers
Sql trigger difference between for and after
SQL
0 vote186 views1 answer
How to get distinct sets of rows using SQL (Oracle)?
SQL
0 vote203 views2 answers
Pl sql auto increment
SQL
8 votes180 views2 answers
Python simple connect to mysql
SQL
0 vote204 views1 answer
Mysql range of dates overlap
SQL

Share