How to get Max top 3 sal from emp table

[akimtiaz]

Thanks for reply but my requirent is like this only top 3 result should not be repeated for example

name sal
john 4000
joseph 4500
abc 4500
xyz 5000
abcl 4200


I want result only xyz,abc9any should not repeat) and abcl