求出男女平均工资,然后对比,若男的比女的高出50%,显示男的工资比女的高多了,若在0.8-1.5范围则显示差不多,其余显示女的工资比男的高多了
use factory
declare @a money,@b money
set @a=(select avg(z.工资) from worker x,salary z where x.姓名=z.姓名 and x.性别='男')
set @b=(select avg(z.工资) from worker x,salary z where x.姓名=z.姓名 and x.性别='女')
select @a as '男职工平均工资',@b as '女职工平均工资'case result
when @a>1.5*@b then '男职工的工资比女职工高多了'
when @a/@b in (0.8,1.5) then '男女职工平均工资差不多'
else '女职工比男职工平均工资高多了'
end as '结果'问题提示case语句出错,请问怎么修改
use factory
declare @a money,@b money
set @a=(select avg(z.工资) from worker x,salary z where x.姓名=z.姓名 and x.性别='男')
set @b=(select avg(z.工资) from worker x,salary z where x.姓名=z.姓名 and x.性别='女')
select @a as '男职工平均工资',@b as '女职工平均工资'case result
when @a>1.5*@b then '男职工的工资比女职工高多了'
when @a/@b in (0.8,1.5) then '男女职工平均工资差不多'
else '女职工比男职工平均工资高多了'
end as '结果'问题提示case语句出错,请问怎么修改
解决方案 »
- 迭代存储过程,生成树,输出结果被截了
- 请问一下在查询视图的时候,是先把几个表进行关联,然后再按条件查询吗?
- 求助:SQL server2000装不上
- 存储过程返回结果集合问题:exce(sql)为什么比select慢很多了?
- process_commands: 进程 1620 发生了严重的异常 c0000005 EXCEPTION_ACCESS_VIOLATION。SQL Server 将终止该进程。
- 复杂的排序问题;[↑↑↑]
- 关于多条件查询 绑定AspNetPager分页控件的问题(困扰了好久)
- sql操作海量数据
- 关于SQL查询的问题,困惑我很久!!!
- 流水记录表不明原因缺少记录
- 关于公式保存为百分率的字段
- 面试一道数据库题目 请大家帮忙解决下
set @a=(select avg(z.工资) from worker x,salary z where x.姓名=z.姓名 and x.性别='男')
set @b=(select avg(z.工资) from worker x,salary z where x.姓名=z.姓名 and x.性别='女')
select @a as 男职工平均工资,@b as 女职工平均工资,
case when @a>1.5*@b then '男职工的工资比女职工高多了'
else case when @a/@b between 0.8 and 1.5 then '男女职工平均工资差不多'
else '女职工比男职工平均工资高多了' end
end as 结果
use factory
declare @a money,@b money
set @a=(select avg(z.工资) from worker x,salary z where x.姓名=z.姓名 and x.性别='男')
set @b=(select avg(z.工资) from worker x,salary z where x.姓名=z.姓名 and x.性别='女')
select @a as '男职工平均工资',@b as '女职工平均工资',
case
when @a>1.5*@b then '男职工的工资比女职工高多了'
when @a/@b between 0.8 and 1.5 then '男女职工平均工资差不多'
else '女职工比男职工平均工资高多了'
end as '结果'
use factory
declare @a money,@b money
set @a=(select avg(z.工资) from worker x,salary z where x.姓名=z.姓名 and x.性别='男')
set @b=(select avg(z.工资) from worker x,salary z where x.姓名=z.姓名 and x.性别='女')
select @a as '男职工平均工资',@b as '女职工平均工资'
,case result
when @a>1.5*@b then '男职工的工资比女职工高多了'
when @a/@b in (0.8,1.5) then '男女职工平均工资差不多'
else '女职工比男职工平均工资高多了'
end as '结果'
-->try
use factory
declare @a money,@b money
set @a=(select avg(z.工资) from worker x,salary z where x.姓名=z.姓名 and x.性别='男')
set @b=(select avg(z.工资) from worker x,salary z where x.姓名=z.姓名 and x.性别='女')
select @a as '男职工平均工资',@b as '女职工平均工资' ,case --result
when @a>1.5*@b then '男职工的工资比女职工高多了'
when @a/@b in (0.8,1.5) then '男女职工平均工资差不多'
else '女职工比男职工平均工资高多了'
end as '结果'