/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

1 vote183 views1 answer
Sql server: query to find out all the places where the table is used
SQL
0 vote169 views1 answer
How to get inserted id in sql server
SQL
37 votes215 views5 answers
FIND DUPLICATES IN COLUMN SQL
SQL
14 votes165 views2 answers
How to auto increment in sql
SQL
1 vote170 views1 answer
Moodle query item quiz
SQL
-1 vote181 views2 answers
Sql query examples
SQL
0 vote172 views1 answer
Doesn't have default value mysql
SQL
1 vote136 views2 answers
Procedure pl/sql
SQL
0 vote219 views1 answer
Parent and child link in mysql
SQL
0 vote174 views1 answer
Mysql Digital Ocean connection problems
SQL

Share