年薪在2000 - 6000之间显示

Question

我有一个查询

SELECT EmployeeID, sum( Salary *12 ) AS Annual_Salary
FROM Employee
GROUP BY Salary
LIMIT 0 , 30

显示年薪，但是我想让在中显示2000到6000之间的年薪

Answer 1

SELECT EmployeeID, sum( Salary *12 ) AS Annual_Salary 
FROM Employee 
GROUP BY Salary
HAVING sum( Salary *12 ) BETWEEN 2000 AND 6000
LIMIT 0 , 30

Answer 2

SELECT EmployeeID, sum( Salary *12 ) AS Annual_Salary
FROM Employee HAVING Annual_Salary BETWEEN 2000 AND 6000
GROUP BY Salary
LIMIT 0 , 30

Answer 3

使用

SELECT temp.* FROM 
   (SELECT EmployeeID, sum( Salary *12 ) AS Annual_Salary 
   FROM Employee GROUP BY  Salary) as temp 
 WHERE temp.Anuual_salary > 2000 AND temp.Anuual_salary < 6000