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
На этой странице сайта вы можете посмотреть видео онлайн FIRST VALUE function in SQL Server длительностью часов минут секунд в хорошем качестве, которое загрузил пользователь kudvenkat 06 Октябрь 2015, поделитесь ссылкой с друзьями и знакомыми, на youtube это видео уже посмотрели 82,911 раз и оно понравилось 509 зрителям. Приятного просмотра!
