sql querry problem

[virender.raj]

Hi
Hai friends ..
Can any one help me to find out the highest salary,second hights salary,and top 5 salary, and least 5 salary from a data base in sql server/oracle.

thank

[chazzy]

sure

SELECT highest_salary, second_hights_salary, top_5_salary, least_5_salary FROM your_table;

but for some reason, i doubt that's how your table is structured so why don't you tell us how its structured!