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 Oid’s with Okey Priority=”2” and Okey Location=”WDC”
Kindly suggest