SQL
Wednesday, October 19, 2011
Sum of Payment per ZipCode, ordered
SELECT SUM([ Net_Paid ]) Payment,
[ Employee_ZIP_Code ] ZIP,
NTILE(10) OVER (ORDER BY SUM([ Net_Paid ])) AS Decile
FROM [SiemensHealthPlanData].[dbo].[unitedHealth]
group by [ Employee_ZIP_Code ]
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment