Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Distinct Rows?
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