Thursday, October 6, 2011

Partitioned by Example

  SELECT User_FirstName,
         User_LastName,
         User_Date,
         User_Email,
         SUM(User_ID) OVER (Partition by User_Salary) as TotalUserSalary,
         row_number() OVER (ORDER BY User_ID DESC) as SrNo
       
  FROM     [TestProject].[dbo].[TBL_USER]

No comments:

Post a Comment