TickTech
asked on
simple SQL 12 code error
--Learning to code SQL, have error, don't understand why is the error. Please ----explain.Thanks
-------------------------- ---------- ---------- ---------- --
USE [AdventureWorks2012]
select BusinessEntityID, Rate, NtileRanking, rank() Over(partition by NtileRanking order by Rate desc)as RankingWithinNtile
from (select BusinessEntityID, Rate,
Ntile(4) Over (Order by Rate Desc) as NtileRanking
from HumanResources.EmployeePay History)
--Msg 102, Level 15, State 1, Line 5
--Incorrect syntax near ')'.
--------------------------
USE [AdventureWorks2012]
select BusinessEntityID, Rate, NtileRanking, rank() Over(partition by NtileRanking order by Rate desc)as RankingWithinNtile
from (select BusinessEntityID, Rate,
Ntile(4) Over (Order by Rate Desc) as NtileRanking
from HumanResources.EmployeePay
--Msg 102, Level 15, State 1, Line 5
--Incorrect syntax near ')'.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
My pleasure!
ASKER