FIRST_VALUE function in SQL Server

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
  • Introduced in SQL Server 2012
  • Retrieves the first value from the specified column
  • ORDER BY clause is required
  • PARTITION BY clause is optional
Syntax :FIRST_VALUE(Column_Name) OVER (ORDER BY Col1, Col2, ...)

 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 Employees

first_value function example

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.

SELECT Name, Gender, Salary,
FIRST_VALUE(Name) OVER (PARTITION BY Gender ORDER BY Salary) AS FirstValue
FROMEmployees

sql server 2012 first_value function

No comments:

Post a Comment

It would be great if you can help share these free resources

[フレーム]

Subscribe to: Post Comments (Atom)

AltStyle によって変換されたページ (->オリジナル) /