I have data in form
and so on..
so id, va1,val2 format..
This id is already sorted based on val 2
I want to select the 2nd element for each id with val2 (ignoring val1)
for example in the above dataset what i want to return is
How to go about this??