Second earliest date group by SUB id

User13140423-Oracle

Hi ,

I have a Subject Area containing Sub Id, Meeting Date, Request Date. I would like to create a dataset that contains an extra column : Second Date, that would be the second earliest date from a date = CAse Request Date is null then Meeting Date else Request Date end, grouped by Sub Id. I need a dataset or a workbook. Is there an option using Logical SQL or Standard SQL?

Thank you