2019-08-05
OVER()
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.
2016-10-25 (first published: 2016-10-03)
643 reads
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.
2016-09-30 (first published: 2015-10-14)
110,160 reads
Blogs
Updated Pluralsight Course – Managing the Kubernetes API Server and Pods
My updated course “Managing the Kubernetes API Server and Pods” in now available on Pluralsight here! If...
Daily Coping 11 May 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
What do you do when technology changes? : T-SQL Tuesday #138
Our host for this month’s TSQL Tuesday is Andy Leonard (blog|twitter). He’d like us...
Forums
Potential set based solution
Hi all, I'm a total novice when it comes to thinking about set based...
Copy value from one row to another if column matches
Hi there, I just don't get it. Need to update rows in same table....
Does lastBatch in sp_who2 really mean the time the user execute a SQL batch
I usually use sp_who2 see who is connected and is active in the SQL...
Ask SSC