00933的最后第二行代码中有一个错误。00000 - "SQL命令未正确结束“。如何解决这个问题？

Question

SELECT Fname, Lname, Salary, 
  contributionRate AS "Individual Contribution Rate", 
  Salary*(contributionRate/100) AS "Individual Contribution", 
  Salary*(contributionRate/100))*0.5 AS "Company Contribution", 
  ((Salary*(contributionRate/100)) + ((Salary*(contributionRate/100))*0.5)) AS "Total Contribution"
FROM (
  SELECT Fname, Lname, Salary, 
    CASE
      WHEN Salary < 30000 THEN 3
      WHEN Salary< 45000 THEN 4
      ELSE 5 
    END  AS "ContributionRate"
    FROM Employee
) AS T
ORDER BY [Total Contribution] DESC, Lname DESC;

Answer 1

我想你在100后面有一个额外的")“：

Salary*([T].[ContributionRate]/100))*0.5 AS "Company Contribution", 

Answer 2

除了@Robert Paulsen所说的：

订购时，需要根据已有变量进行订购：

ORDER BY [Total Contribution] DESC

不会起作用。您需要做的是：

ORDER BY ((Salary*(contributionRate/100)) + ((Salary*(contributionRate/100))*0.5)) DESC