Re: Using distinct across several columns

Hi Steve,

your example was:
  name street phone order_number

1. bob Oak st 555-1212 2525
2. bob Oak st 555-1212 2521
3. fred Oak st 555-1212 2529
4. jerry Pine st 555-1212 2522
5. bob Oak st 555-1212 2527
6. jerry Pine st 402-1212 2560

One can easily determine that rows 3,4 and 6 shall be returned. But how should the rdbms know which 'bob'-row you want to see? Just my 0.02 $.

Greetings,
Guido

"Steve Wicklund" <savant_7_at_hotmail.com> schrieb im Newsbeitrag news:5de96e4e.0301141828.2248c8be_at_posting.google.com...
> That will retrieve rows that are unique across only the *three*
> columns-- and not order_number? I am looking for unique combination of
> values across only three columns--- but still retrieve the value of
> all four.
> Cheers!
>
>
>
> "Alistair Thomson" <thomson_alistair_at_no.spam.yahoo.co.uk> wrote in message
news:<b01ar6$h38$1$8302bc10_at_news.demon.co.uk>...
> > Hi
> >
> > try
> >
> <truncated>
>
>
> > > Cheers.
Received on Wed Jan 15 2003 - 00:56:30 CST