question

Sandeepkonnam avatar image
Sandeepkonnam asked

SQL oracle

I have a requirement where I have list of records in table with I'd and timestamp....I need to fetch the latest record which is 30 minutes from the latest timestamp.... Need an oracle query for same

Example

1  21- feb-2018 9:00
2  21- feb-2018 8:46  
3  21- feb-2018 8.48
4  21- feb-2018 8.30
15 21- feb-2018 8.25

Output

421- feb-2018 8.30

Any help please

sqloracle
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.