Need distinct for multiple fields

See more:

SQL-Server

Hi friends,

I'm not sure how to get this please look in to this and help me!

Code

F1 F2 F3 F4
1 1 1 2
2 1 1 2
3 2 2 1
4 2 2 1


Fields----F1 F2 F3 F4

O/P

F1 F2 F3 F4
2 1 1 2
4 2 2 1


my code:

SELECT F1,  F2,  F3 , F4
FROM test as A
WHERE F2=
(SELECT MAX(B.F2)
FROM test as B
WHERE A.F3 = B.F3 )

this code helpful to select but how to improve this code!