Arto Viitanen wrote:
> 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.
There are some additional non-key columns also exist in the Table.
Sorry, I did not include them as I thought they are necessary for the
SQL formation.
Received on Wed Jan 17 2007 - 00:52:21 CST
