Hi,
I have a table storing data like this

Oid OKey OValue
1 Status Open
1 Priority 1
1 Name TTT
1 Location NYC
2 Status Open
2 Priority 2
2 Name TYY
2 Location WDC
3 Status Close
3 Priority 2
3 Name TYZ
3 Location WDC

Now, I need to write a query to fetch Oids with Okey Priority=2 and Okey Location=WDC

Kindly suggest