/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 vote358 views2 answers
How to delete the rows with null values in mysql
SQL
2 votes375 views1 answer
Oracle to_char number format percentage
SQL
3 votes373 views1 answer
Create a table with an id in mysql
SQL
0 vote336 views1 answer
How to check if there is no database schema
SQL
12 votes376 views2 answers
Select into insert sql server
SQL
-1 vote352 views1 answer
Mysql order by on condition
SQL
0 vote372 views1 answer
Suhaib
SQL
1 vote383 views3 answers
How to pass password to mysql command line
SQL
2 votes355 views1 answer
Column names in oracle sql
SQL
0 vote345 views1 answer
How to query all tables mysql at the same time
SQL

Share