how can i get the salary according to rank and arrange the salary into the ascending order

Answer 1

select salary from table group by rank order by asc

Answer 2

use group by

Answer 3

how can get max salary

Answer 4

select salary from tablename
orderby salary desc

this will give you result of hhighest salary drawn first to the lowest salary drawn

Answer 5

how can get top salary

Answer 6

To get max salary

select max(salary) from tablename

Answer 7

SELECT salary FROM salary_table ORDER BY asc

Answer 8

select max (salary),rank from salary_table groupby rank