So if there 5 rows which gets grouped by other 2 columns, which date you want to display ?
Could you please give the sample data and the expected output.
Thanks for your reply,
The query was to return values to create a chart in jdeveloper and I was thinking of using the date as a criteria.
Instead I used the date with default values, an interval with -100 years and +100 years from today.