/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

17 votes318 views2 answers
How to assign date field for table in mysql
SQL
0 vote334 views1 answer
Oracle index hint
SQL
0 vote350 views1 answer
Migrations.RunSQL
SQL
1 vote357 views1 answer
Job for mariadb.service failed because the control process exited with error code. see "systemctl status mariadb.service" and "journalctl -xe" for details.
SQL
18 votes347 views3 answers
'Client does not support authentication protocol requested by server; consider upgrading MySQL client', sqlState: '08004',
SQL
0 vote314 views1 answer
Split a string with expression and get the last value of split sql
SQL
0 vote333 views1 answer
SQL Server modify_timestamp trigger
SQL
0 vote373 views1 answer
SQLServerException.makeFromDatabaseError
SQL
0 vote349 views1 answer
Uninstall mysql ubuntu 18.04 stackoverflow
SQL
15 votes337 views2 answers
Sql order by multiple columns
SQL

Share