Re: Finding rows with column1+column2 values are unique

From: Arto Viitanen <arto.viitanen_at_csc.fi>
Date: Wed, 17 Jan 2007 08:30:00 +0200
Message-ID: <45adc269$0$8950$ba624cd0@newsread.funet.fi>

qazmlp1209_at_rediffmail.com wrote:

>

> I have put my requirement wrongly. Here is the correct one?
>
> COLUMN1 is a key column.
> COLUMN2, COLUMN3 are the non-key columns.
>
>
> We have to find out the number of COLUMN1s, where there is a 1:1
> relation between all the COLUMN2 and COLUMN3 values for a given COLUMN1
> value.

Since column1 is a key, for each column1 value there should be only one column2, column3 combination. If not, column1 is not actually a key.

-- 
Arto Viitanen, Csc. LTd
Espoo, Finland

Received on Wed Jan 17 2007 - 00:30:00 CST