/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 vote165 views1 answer
Renombrar tabla mysql
SQL
0 vote181 views1 answer
How to convert external table to managed table in hive
SQL
13 votes180 views4 answers
Command line mysql import
SQL
0 vote160 views1 answer
Get who is hired in specific month in sql
SQL
1 vote185 views1 answer
Sql first day quarter
SQL
94 votes377 views4 answers
Create database postgres
SQL
-1 vote166 views2 answers
How to display top 50 rows?
SQL
0 vote161 views1 answer
Formatting code with SQL Developer
SQL
0 vote193 views2 answers
Create-toys-table-with-toy_name-column
SQL
9 votes202 views1 answer
Identity insert on sql server
SQL

Share