/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

10 votes481 views4 answers
Sql server pagination
SQL
1 vote366 views1 answer
Select count distinct multiple columns sql server
SQL
1 vote405 views1 answer
Last 24 HOUR data in mysql
SQL
0 vote363 views1 answer
Wincc 7.4 to sql stackoverflow
SQL
1 vote374 views1 answer
Spark sql convert string to date
SQL
5 votes373 views1 answer
Dbms_metadata.get_ddl table
SQL
4 votes345 views1 answer
Postgresql change default value
SQL
0 vote378 views1 answer
Postgresql port 5432 not open
SQL
1 vote372 views1 answer
Sql server: query to find out all the places where the table is used
SQL
0 vote363 views1 answer
Call function sql oracle with output put line
SQL

Share