Suggested Videos
Part 112 - Calculate running total in SQL Server 2012
Part 113 - NTILE function in SQL Server
Part 114 - Lead and Lag functions in SQL Server 2012
In this video we will discuss FIRST_VALUE function in SQL Server
FIRST_VALUE function
FIRST_VALUE function example WITHOUT partitions : In the following example, FIRST_VALUE function returns the name of the lowest paid employee from the entire table.
FIRST_VALUE function example WITH partitions : In the following example, FIRST_VALUE function returns the name of the lowest paid employee from the respective partition.
Part 112 - Calculate running total in SQL Server 2012
Part 113 - NTILE function in SQL Server
Part 114 - Lead and Lag functions in SQL Server 2012
In this video we will discuss FIRST_VALUE function in SQL Server
FIRST_VALUE function
- Introduced in SQL Server 2012
- Retrieves the first value from the specified column
- ORDER BY clause is required
- PARTITION BY clause is optional
FIRST_VALUE function example WITHOUT partitions : In the following example, FIRST_VALUE function returns the name of the lowest paid employee from the entire table.
SELECT Name, Gender, Salary,
FIRST_VALUE(Name) OVER (ORDER BY Salary) AS FirstValue
FROM EmployeesFIRST_VALUE function example WITH partitions : In the following example, FIRST_VALUE function returns the name of the lowest paid employee from the respective partition.
SELECT Name, Gender, Salary,
FIRST_VALUE(Name) OVER (PARTITION BY Gender ORDER BY Salary) AS FirstValue
FROM Employees
No comments:
Post a Comment
It would be great if you can help share these free resources