Home » Other » Test » HOW DO I FILTER TO EXCLUDE A ROW IN DISCOVERER (ORACLE DISCOVERER)
HOW DO I FILTER TO EXCLUDE A ROW IN DISCOVERER [message #563217] Thu, 09 August 2012 17:03 Go to next message
HHHHH
Messages: 1
Registered: August 2012
Junior Member
I have managed to apply filters and have limited the results down to a point but I am now stuck. Can anyone help please.

I need to filter out the first row with the reason for the filter/exclusion being that in column Y the results is a single record only/unique result. All other rows have multiple results for a value in column Y.


X Y Z
C1 A C2
C1 B C2
C1 B C3
C1 C C2
C1 C C3
C1 D C2
C1 D C3

Thanks

[Updated on: Thu, 09 August 2012 17:31]

Report message to a moderator

Re: HOW DO I FILTER TO EXCLUDE A ROW IN DISCOVERER [message #563220 is a reply to message #563217] Fri, 10 August 2012 01:04 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" button to verify.
Also always post your Oracle version, with 4 decimals.

Regards
Michel
Re: HOW DO I FILTER TO EXCLUDE A ROW IN DISCOVERER [message #563235 is a reply to message #563220] Fri, 10 August 2012 05:58 Go to previous message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Roger,

note that you posted a message in our Test forum; don't expect a "real" answer to your question here. Would you like us to move it into Reports & Discoverer forum?
Previous Topic: Oracle 10g/11g Training By Subject matter Experts
Next Topic: TEST
Goto Forum:
  


Current Time: Thu Mar 28 17:48:38 CDT 2024