/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 vote187 views1 answer
Mysql order by on condition
SQL
0 vote170 views1 answer
How to order result of subquery in select
SQL
1 vote184 views1 answer
Trigger in postgresql to change incoming entry
SQL
0 vote172 views1 answer
Opening xampp mysql in cmd ubuntu
SQL
0 vote177 views1 answer
Mysql workbench format date
SQL
0 vote179 views1 answer
Can't connect to postgresql mac os
SQL
0 vote165 views1 answer
How to Group by and concatenate arrays with all columns in PostgreSQL
SQL
0 vote177 views1 answer
Copy column from one table to another without column duplicate postgres
SQL
10 votes171 views1 answer
Dba_dependencies
SQL
0 vote173 views1 answer
Like sql for second letter of the family name
SQL

Share