Choosing Rows or Range

An Intro to SQL Window Functions

Learn about some window function basics in T-SQL

Getting top ranked employee detail for each department

Using OVER clause with ROW_NUMBER() function to get top ranked employee detail as per each department.

Understanding the OVER Clause in SQL Server

Having a solid knowledge of the window functions if vital to high performance T-SQL Code. The key to these functions is how the OVER clause is used. This article will dive into how to use the OVER clause.