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.
Apr 17 at 09:51 AM
@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.
Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.
Once you sign in you will be able to subscribe for any updates here
Answers and Comments
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
Help with a complex SQL query
Get Sum of Columns based on another table which contains column names.
show sum of column with group by
How to aggregate multiple child columns with parent column only once when not grouping by parent?
Retrieve latest records in each week over time
Extensive group by
Is there a way to combine multiple rows into one row?
Need to find the most recent date based off the most recent time
Count Data from multiple tables