/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 vote142 views1 answer
Not between mysql
SQL
0 vote144 views1 answer
FILENAME /usr/bin/mysql does not exists. Make sure correct path is set in /etc/dump admin/settings.conf.
SQL
0 vote201 views1 answer
Print hello world in plsql
SQL
5 votes152 views4 answers
Change auto increment mysql
SQL
0 vote164 views1 answer
Find how many tables in database sql query
SQL
-1 vote196 views1 answer
Minus vs except in sql
SQL
2 votes148 views3 answers
Postgresql reset auto increment
SQL
0 vote192 views1 answer
T-sql delete view if exists
SQL
2 votes222 views1 answer
Oracle run_duration to number
SQL
0 vote133 views1 answer
Add column to table with default value plsql
SQL

Share