Extensive group by and having

Please help!!! I need to segregate/group data that can withhold same group no according to the scenario. The Master File is the data in oracle and the scenarios from the result table are expected.

alt text

sql.png (19.9 kB)
more ▼

asked Apr 17 at 09:51 AM in Default

avatar image


@chloe_flaire3692 It is not clear how you would like your results to look. To segregate the groups into 5 buckets is a pretty trivial task, but how should the results be displayed? Certainly they cannot be displayed as they are displayed in your screenshot. Please clarify. Also, it would be helpful to know the version of Oracle that you have.

Apr 17 at 12:52 PM Oleg
(comments are locked)
10|1200 characters needed characters left

0 answers: sort voted first
Be the first one to answer this question
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Apr 17 at 09:51 AM

Seen: 22 times

Last Updated: Apr 17 at 12:52 PM

Copyright 2018 Redgate Software. Privacy Policy