/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

0 vote318 views1 answer
Hw to delete a procedure in pl sql
SQL
0 vote300 views1 answer
Get time component of datetime sql
SQL
1 vote311 views2 answers
Restart identity cascade
SQL
0 vote313 views1 answer
Mssql view column data type
SQL
3 votes323 views2 answers
Sql paging query
SQL
0 vote323 views1 answer
Datetime postgres typeorm
SQL
0 vote336 views1 answer
Replace divide by zero error with 0 in sql
SQL
6 votes319 views2 answers
Find mysql version linux
SQL
0 vote332 views1 answer
Varchar2 length in oracle
SQL
0 vote309 views1 answer
Plpgsql coalesce equivalent for empty string
SQL

Share