Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to get first purchage date and last purchage date of the vehicle in my query.

kolipakaJul 1 2016 — edited Jul 2 2016

Hi ,

I have three records in my table with three vehicle sold details. Now, i need first and last purchase date records to be fetched from my query.

Data like below:

source_id      vehicle_no       Driver_name     relation               purchase_Date         end_date

534534          ABC123          XYZ                  Driver                 23-jun-2014              30-Dec-2014

543545          ABC123          ABC                 Keeper                24-jan-2015               31-dec-2015

345346          ABC123          XYZ                  Driver                 01-jan-2016                  NULL

Regards,

LRK
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 30 2016
Added on Jul 1 2016
16 comments
2,689 views