SQL Server 2005/2008 Queries Training Video: An Introduction to t he Ranking and Window Functions

An Introduction to the Ranking and Window Functions - view details
The last topic covered in chapter three will be ranking functions and window functions. In this video Scott will give an in depth overview of both ranking and window functions.

Highlights from this video:Window functions
segment of the result setpartition
Ranking function
ranks rows according to the function/window
OVER clause
Four ranking functions
ROW_UNDER, RANK, DENSE_RANK, NTILE
and much more Source: http://www.learnitfirst.com/Course/160/Video/2309/Ranking-and-Window-Functions-Intro.aspx Course: http://www.learnitfirst.com/Course/160/SQL-Queries-2008.aspx Skill Level: 300 (Intermediate) Length: 15:30 (45.5MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: sql server, queries, ranking functions, window functions, partition, over clause, row_under, rank, dense_rank, ntile

This video comes from the SQL Server 2005/2008 Queries online training course, Writing Queries for SQL Server (2005/2008 Edition). And be sure to check out even more SQL Server 2008/2005 Query Writing training videos.