Analytical Functions - new T-SQL features in SQL Server 2012

a.   Analytical Functions - new T-SQL features in SQL Server 2012

Introduction: 

Description: Below are good new Sql Server Analytical Functions. Please go through one by one. 

                                          i.    LAG()
                                        ii.    LEAD()
                                       iii.    LAST_VALUE()
                                      iv.    FIRST_VALUE()
                                        v.    CUME_DIST()
                                      vi.    PERCENTILE_DISC ()
                                     vii.    PERCENT_RANK()
                                    viii.     PERCENTILE_CONT()


If you have any queries or suggestions, please feel free to ask in comments section.
Share this post :

Post a Comment

Please give your valuable feedback on this post. You can submit any ASP.NET article here. We will post that article in this website by your name.

 
Support : Ranga Rajesh Kumar
Copyright © 2012. ASP.NET Examples - All Rights Reserved
Site Designed by Ranga Rajesh Kumar