Home » Developer & Programmer » Reports & Discoverer » Non Unique (OracleBI Discoverer 10g (
Non Unique [message #315726] Tue, 22 April 2008 10:13 Go to next message
Messages: 1
Registered: April 2008
Location: Staffordshire
Junior Member
Is there a way to show non unique numbers from a field?

I have a list of employee numbers that have duplicate assignment numbers. All I want to see is those duplicates, is this possible.

Many thanks in advance.
Re: Non Unique [message #315925 is a reply to message #315726] Wed, 23 April 2008 04:40 Go to previous message
Messages: 913
Registered: March 2005
Location: Netherlands
Senior Member
Yes, you can create a calculation with a RANK function in it (see SQL reference for details) and then add a filter on RANK > 1.
Previous Topic: Letter spacing problem in PDF reports developed in D2K
Next Topic: page item
Goto Forum:

Current Time: Thu Jul 27 00:05:48 CDT 2017

Total time taken to generate the page: 0.08339 seconds