Specialized Query

[robboll]

I am trying to develop a query that displays 5 unless there is a 3 for
each owner in the results set. To better explain with sample data.
I have a data set as follows:

Owner Value
A 3
A 5
B 5
C 5
C 3

So when the query is run it displays:

Owner Value
A 3
B 5
C 3

Any tips appreciated!!!!

RBollinger

 

[MGFoster]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

SELECT Owner, Min(Value)
FROM table_name
WHERE Value IN (3,5)
GROUP BY Owner
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQ+FGhYechKqOuFEgEQKwzQCg+Sb4WRN+WfLBoJKZKjyJjh+zS4IAnAiT
tZYIuU2GqCoYd66JEpkcTfT0
=TIC+
-----END PGP SIGNATURE-----