Over clause in SQL Server - Part 30
Subscribe to IT PORT : / itport28
SQL Server Tutorial in Tamil : • SQL Server Tutorial in Tamil
SQL Server Concepts in Tamil : • SQL Server Concepts in Tamil
SQL Server Analytic Functions in Tamil : • SQL Server Analytic Functions Tamil
SQL Server Tutorial : • SQL Server Tutorial
SQL Server Concepts : • SQL Server Concepts
SQL Server Analytic Functions : • SQL Server Analytic Functions
OVER clause Determines the partitioning and ordering of a rowset before the associated window function is applied. That is, the OVER clause defines a window or user-specified set of rows within a query result set. A window function then computes a value for each row in the window. We can use the OVER clause for Ranking, Aggregate and Analytic functions