34,590
社区成员
发帖
与我相关
我的任务
分享
--笔误
select
income as '张三的收入',
(select avg(income) from 员工表 where sex = '男') '男员工的平均收入',
(select avg(income) from 员工表 where sex = '女') '女员工的平均收入'
from 员工表
where name = '张三'
select
income [张三收入],
(select avg(sex) from 员工表 where sex = '男') [男员工的平均收入],
(select avg(sex) from 员工表 where sex = '女') [女员工的平均收入]
from 员工表
where name = '张三'
select 张三收入=(select sun(income) from 表 where name='张三'),男人数=(select cont(*) from 表 where age='男'),
男平均收入=(select avg(income) from 表 where age='男'),女平均收入=(select avg(income) from 表 where age='女')
SELECT (SELECT SUM(income) FROM 员工表 WHERE NAME='张三')张三的收入,
(SELECT COUNT(*) FROM 员工表 WHERE SEX='男' )男的员工人数,
(SELECT AVG(income) FROM 员工表 WHERE SEX='男' ) 男员工的平均收入,
(SELECT AVG(income) FROM 员工表 WHERE SEX='女' ) 女员工的平均收入
FROM 员工表
select
income as '张三的收入',
(select avg(sex) from 员工表 where sex = '男') '男员工的平均收入',
(select avg(sex) from 员工表 where sex = '女') '女员工的平均收入'
from 员工表
where name = '张三'