OraFAQ Forum: Test » HOW DO I FILTER TO EXCLUDE A ROW IN DISCOVERER

Home » Other » Test » HOW DO I FILTER TO EXCLUDE A ROW IN DISCOVERER (ORACLE DISCOVERER)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

HOW DO I FILTER TO EXCLUDE A ROW IN DISCOVERER [message #563217]

Thu, 09 August 2012 17:03

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

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

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

Littlefoot
Messages: 21823
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?

Report message to a moderator

Previous Topic:	Oracle 10g/11g Training By Subject matter Experts
Next Topic:	TEST

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Feb 07 11:52:07 CST 2025