SQL Querry有理代数 [英] sql querry rational algebra

问题描述

创建查询队列以显示薪水高于所有职员薪水的员工.

create a querry to display the employees that earn a salary that is higher than the salary of all clerks.

推荐答案

您的查询可能类似于

Your query might be something like

select * from employees A where salary > (select max(salary) from employees where employeeType = 'clerk')

我认为要求是薪水高于所有业务员的

所以应该是

选择*从员工那里薪水> (从EmployeeType =文员"的员工中选择Sum(Salary))

I think the requirement is Salary higher than all clerk''s

So it should be

Select * From Employees where Salary > (Select Sum(Salary) From Employees where EmployeeType = ''Clerk'')

这篇关于SQL Querry有理代数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！