Re: Distinct Rows?

Yes of course if you ask
select customerNumber
from customer
where status = 1
you get two rows, because there are two rows, distinct or not (and they are distinct)
Obviously you want to know
select min(customernumber)
from customer
where status = 1

Hth,
Sybrand Bakker, Oracle DBA

Kevin White <kevin_white_at_lagan.com> wrote in message news:953565654.688.0.nnrp-04.9e9859ae_at_news.demon.co.uk...
> Does anyone know how to;
>
> I have a table like so,
>
> customerNumber Status
> 10010 1
> 10011 1
> 10015 2
>
> I want to select the first customer number from the list with a Status of
1.
>
> If I try this in a stored procedure it wants to return both customer
number
> 10010 and 10011.
>
> Thanks Kevin...
>
>
Received on Mon Mar 20 2000 - 09:56:18 CST