FIRST VALUE function in SQL Server
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
Healthy diet is very important both for the body and mind. If you like Aarvi Kitchen recipes, please support by sharing, subscribing and liking our YouTube channel. Hope you can help.
/ @aarvikitchen5572
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 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
Text version of the video
http://csharp-video-tutorials.blogspo...
Slides
http://csharp-video-tutorials.blogspo...
All SQL Server Text Articles
http://csharp-video-tutorials.blogspo...
All SQL Server Slides
http://csharp-video-tutorials.blogspo...
All Dot Net and SQL Server Tutorials in English
https://www.youtube.com/user/kudvenka...
All Dot Net and SQL Server Tutorials in Arabic
/ kudvenkatarabic
Sur cette page du site, vous pouvez voir la vidéo en ligne FIRST VALUE function in SQL Server durée heure minute seconde en bonne qualité , qui a été Téléchargé par l'utilisateur kudvenkat 06 octobre 2015, Partagez le lien avec vos amis et connaissances, sur youtube cette vidéo a déjà été regardée 82,911 fois et il a aimé 509 téléspectateurs. Bon visionnage!
