Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Second earliest date group by SUB id

Question
25
Views
0
Comments
User13140423-Oracle
User13140423-Oracle Rank 2 - Community Beginner
edited Dec 17, 2024 10:21AM in Oracle Analytics Cloud and Server

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