How to write a query for this?

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 Thu Dec 14 2000 - 16:50:25 CST