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.
(no tags)
Presented by Sandip Pani at SQLBits XI