/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 vote324 views2 answers
Demmarrer un service mysql teminal cmd
SQL
0 vote348 views1 answer
TSQL Code Snippet For Optimized Sales Query
SQL
0 vote407 views1 answer
Mysql get nested records
SQL
1 vote333 views1 answer
Postgresql create table with timestamp
SQL
5 votes338 views1 answer
Oracle sysdate - 1 month
SQL
0 vote346 views1 answer
Ubuntu stop mysql from starting on boot
SQL
0 vote339 views1 answer
Sql alter table add column if exists
SQL
0 vote355 views1 answer
Sql express database size limit
SQL
0 vote377 views1 answer
Sql server phone constraint
SQL
0 vote376 views1 answer
Comparing with today and yesterday record in sql query
SQL

Share