Partition Or Grouping By in SQL Server

     Partition Or Grouping By:

To display category wise  information .

This partition is useful for

a)      SELECt PartyID,PartyIncome,Rank() over (Orger by PartyIncome DESC)

FROM Party

b)      SELECT PartID,PartyIncome,Dense_Rank() Over(Order by PartyIncome DESC)

FROM Party

c)       SELECT PartyID,PartyIncome,Row_Number over (Order by PartyIncome DESC)

FROM Party

d)      SELECT PartyID,PartyIncome,NTile(9) over

(order by PartyIncome DESC) FROM Party

Distributes 9 Ranks across all rows

Assume 40 records è40/9=4 reminder

1è4è4+1

2è4è4+1

3è4è4+1

4è4è4=1

5è4