nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

Home
Oracle Analytics and AI
Oracle Analytics and AI Forums
Oracle Analytics Forums
Oracle Analytics Forum

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?