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

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

Introduction: 

In my previous posts we have seen what is Transact-Sql in sql server and What are new top features of T-Sql in server. This is one of the best sql server interview Questions and answers. Watch more ASP.NET, C#.NET, Jquery, Sql Server, HTML5, HTML, CSS, JQUERY UI Interview questions from here. 

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.