sql语句查询计算机系,sql语句查找考试

SQL语句查询题,在线等答案

你光说了表名，没告诉列名怎么查询啊，根据你的说法，部门表里肯定有一列是员工表的外键，这里假设员工表主键为 staffID，薪资为salary， 部门表 部门名称为departmentName

(1),select * from staff where staffID in (select staffID from department where departmentName='市场部')

或者使用内连接查询 select s.* from staff s inner join department d on s.staffID=d.staffID where departmentName='市场部')

(2).select departmentName ,count(staffID) from department group by departmentName having count(staffID) >5 desc count(staffID)

(3).select staffID, case salary when salary >=300 then salary+500 when salary >= 1000 and salary

另外一种情况 是员工表里有部门表的外键， 如departmentID，那么

(1),select * from staff where departmentID in (select departmentID from department where departmentName='市场部')

或者使用内连接查询 select s.* from staff s inner join department d on s.departmentID=d.