表中有工号,姓名,性别,工资,部门号:
1.在表p中查询工资比所在部门平均高的职工信息.这个写不出来.
2.在表p中查询所有工资比赵明华高的职工信息.语句如下:
select * from p where p.wage>(select p.wage from p where p.name="赵明华")

偶也是试试
1
select *
from p inner join
(select groupid, avg(p1.wag) as avgwag
from p p1
group by p1.groupid) t
on t.groupid=p.groupid
where p.wag>t.avgwag

2，个人觉得没有什么问题

[此贴子已经被作者于2006-1-5 18:14:44编辑过]

select * from p where 工资>（select avg(工资) from p where 部门号='部门号1') and 部门号='部门号1'
union
select * from p where 工资>（select avg(工资) from p where 部门号='部门号2') and 部门号='部门号2'
union
select * from p where 工资>（select avg(工资) from p where 部门号='部门号3') and 部门号='部门号3'

1.在表p中查询工资比所在部门平均高的职工信息.这个写不出来.
select * from table as a , (select avg(gz) as gz from table) as b where a.gz > b.gz

2.在表p中查询所有工资比赵明华高的职工信息.语句如下:
select * from p where p.wage>(select p.wage from p where p.name="赵明华")

select * from table as a , (select wage as wage from table where name = "赵明华") as b where a.wage > b.wage