Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Distinct Rows?

Distinct Rows?

From: Kevin White <kevin_white_at_lagan.com>
Date: Mon, 20 Mar 2000 15:17:04 -0000
Message-ID: <953565654.688.0.nnrp-04.9e9859ae@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:17:04 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US