/SQL/Select last row in sql

Select last row 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
  (SELECT * FROM tableName ORDER BY col1 LIMIT 1)        AS first,
  (SELECT * FROM tableName ORDER BY col1 DESC LIMIT 1)   AS last
;

4

Source: stackoverflow.com

Select last row in sql

SELECT TOP 1 * FROM Table ORDER BY ID DESC

1

Source: stackoverflow.com

Select last row from SQL Table

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

1

Source: stackoverflow.com

Similar codes

0 vote251 views1 answer
Changing name of column and datatype in sql
SQL
0 vote275 views1 answer
Sql to search who modified
SQL
4 votes228 views1 answer
Check database name postgresql
SQL
0 vote254 views2 answers
Replace null with 0 in sql
SQL
2 votes239 views1 answer
Sql column values comma separated
SQL
7 votes240 views3 answers
Can't connect to local mysql server through socket '/tmp/mysql.sock' (2)
SQL
0 vote269 views1 answer
Site:av.ru "files"
SQL
3 votes253 views1 answer
Start mysql server by terminal in linux
SQL
1 vote180 views1 answer
How to run sql script
SQL
1 vote246 views1 answer
Date_part mysql
SQL

Share