In this session I'll be exploring all of the below new analytical functions of SQL server 2012.
- CUME_DIST
LEAD
LAG
FIRST_VALUE
LAST_VALUE
PERCENTILE_CONT
PERCENTILE_DISC
PERCENT_RANK
I'll be explaining how this functions works , where we can use these functions. How we were achieving the same in earlier version and now how simple it is to achieve the same.