Re: How to write a query for this?

Try this:

SELECT empid, MIN(location)
FROM mytable
WHERE location IN('FO', 'HQ')
GROUP BY empid

If I got the syntax wrong for the IN, you could do WHERE location = 'FO' OR location = 'HQ'

Rick

Gad Krosner wrote:

> Hi There!
>
> I have a table MYTABLE with columns EMPID and LOCATION (and other
> columns).
> LOCATION may be "HQ" or "FO" and one EMPID may have both HQ and FO.
>
> I want to retrieve data but not more than one row per EMPID. If an
> EMPID has both HQ and FO, I want to retrieve only the row with FO.
>
> How do I write that query?
>
> Thanks.
>
> Sent via Deja.com
> http://www.deja.com/
  Received on Sat Dec 16 2000 - 12:31:09 CST