In this post i will discuss how to use row_number function in where clause in SQL Server.This post is also valid for other window functions like rank(),dense_rank(),ntile() etc. Let us consider the T-SQL query which is using a window function named row_number(). The data was also partitioned by two locations North and South. I am […]