How to query the most recent record in DB2?

2 years ago
William Carter
1 minute

You can use the following SQL query to retrieve the latest record:

SELECT *
FROM your_table
ORDER BY your_timestamp_column DESC
FETCH FIRST 1 ROW ONLY;

Please replace “your_table” with the name of the table you want to query and “your_timestamp_column” with the column name used to determine the records. This will sort the results in descending order of the timestamp column and only return the first row, which is the most recent record.

bannerAds