SQL查询比例的问题

Question

查询工资在1000至1500之间的员工在所有员工中所占的比例！

这个该怎么查询啊~求各位高手解答

Answer 1

select ((select count(*) from 表名 where 工资 between 1000 and 1500 )*100/(select count(*) from 表名))

显示的直接就是百分比.

Answer 2

select a.number1/b.number2 from
(select count(*) number1 from 表名 where 工资 between 1000 and 1500) a,
(select count(*) number2 from 表名) b

Answer 3

select rtrim(cast(sum(case when 工资 between 1000 and 1500 then 1 else 0 end)*1.0/count(*)*100) as numeric(18,2)))+'%'
from table