首页 \ 问答 \ 员工的平均工资超过平均工资但低于经理的工资？(Staff with more than Average Salary but less then that of a Manager? (SQL))

员工的平均工资超过平均工资但低于经理的工资？(Staff with more than Average Salary but less then that of a Manager? (SQL))

 你好，我在这里做什么不知道做什么是SQL的初学者，我已经学会了如何显示所有薪水超过平均水平的人。  
 我现在需要向所有薪水大于平均值但低于主管的人员展示。  
 这是我输入的代码，以使工资大于平均值。  
select first_name, last_name, salary
from staff
where salary >(select avg(salary) from staff);
 
 这是第一部分已经完成，但我不知道如何将Salarys设法为：人们的工资低于主管的工资但高于平均工资。  
 表包含：  
 First_Name，Last_Name，Role，Salary 

Hello I am at a loss what to do here being quite the beginner at SQL , I have already calcalated how to show all people that have a Salary which is more than average.  
I now need to show all people with a Salary greater than the Average but less than that of the Supervisor.  
Here is the Code I entered to get the Salary greater than Average.  
select first_name, last_name, salary
from staff
where salary >(select avg(salary) from staff);
 
This is the first section done but I don't know how to calcalate Salarys for if: People have a salary less then that of a supervisor but more than the Average.  
The Tables contains:  
First_Name, Last_Name, Role, Salary 

原文：https://stackoverflow.com/questions/43646922

更新时间：2022-03-21 07:03

最满意答案

 安装您希望使用的.NET Framework的开发包，然后https://www.microsoft.com/en-us/download/details.aspx?id=42637 ：  
 
  在“解决方案资源管理器”中，打开要更改的项目的快捷菜单，然后选择“属性”。  
  在属性窗口的左列中，选择“应用程序”选项卡。  
  在“目标框架”列表中，选择所需的版本。  
  在出现的验证对话框中，选择是按钮。 该项目卸载。 重新加载时，它会以您刚刚选择的.NET Framework版本为目标。  
 
 您应该知道某些功能在以后的版本中可能会或可能不会在更改为不同版本的.NET框架时修复它们  
 根据我的经验，我通常在重启后在VS中显示新版本的.NET Framework。 我现在正在使用VS2013 

Install the developer pack of the .NET Framework you wish to use then https://www.microsoft.com/en-us/download/details.aspx?id=42637: 
 
 In Solution Explorer, open the shortcut menu for the project that you want to change, and then choose Properties. 
 In the left column of the properties window, choose the Application tab. 
 In the Target Framework list, choose the version that you want. 
 In the verification dialog box that appears, choose the Yes button. The project unloads. When it reloads, it targets the .NET Framework version that you just chose. 
 
You should know that certain features might or might not be available in a later version and you might need to fix them when changing to a different version of the .NET framework 
In my experience, I usually have a new version of the .NET Framework displayed in VS after a restart. I am using VS2013 at the moment

员工的平均工资超过平均工资但低于经理的工资？(Staff with more than Average Salary but less then that of a Manager? (SQL))

最满意答案

相关问答

.net Dll在转换为4.5.2后显示框架4.0(.net Dll shows framework 4.0 after being converted to 4.5.2)[2023-05-05]

无法在Visual Studio 2013中定位.NET Framework 4.5(Unable to target .NET Framework 4.5 in Visual Studio 2013)[2022-08-21]

Visual Studio 2013和.NET 4.6(Visual Studio 2013 and .NET 4.6)[2023-12-29]

如何在Visual Studio中选择.NET 4.5.2作为目标框架(How to select .NET 4.5.2 as a target framework in Visual Studio)[2023-03-27]

使用目标框架.Net 4.5.2获取System.AccessViolationException(Getting a System.AccessViolationException with targeting framework .Net 4.5.2)[2023-09-09]

Visual Studio无法识别目标框架(Visual Studio does not recognize target framework)[2024-01-20]

Visual Studio 2013 - 定位.net 2(Visual Studio 2013 - Targeting .net 2)[2023-05-26]

如何让Visual Studio 2013允许我以.NET Framework 4.5.2为目标？(How do I get Visual Studio 2013 to allow me to target .NET Framework 4.5.2?)[2022-10-22]

Visual Studio 2017 .NET Framework 4.5.2(Visual Studio 2017 .NET Framework 4.5.2)[2023-07-13]

安装.net framework 4.5.2后打开所有VS 2013解决方案时出现异常(Exception when opening all VS 2013 solutions after installing .net framework 4.5.2)[2022-03-12]

相关文章

最新问答