(Rajendra Gupta) SQL Server 2012 introduces new analytical functions FIRST_VALUE and LAST_VALUE. These new functions allow you to get the same value for the first row and the last row for all records in a result set. In this tip we will explore these functions and how to use them.
Read More - Register for Free Membership
SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help