WORKING WITH ANALYTICAL FUNCTIONS

ADVANCED SQL, ANALYTICAL FUNCTIONS / By / 24/07/2022 / 1 Comment

WORKING WITH ANALYTICAL FUNCTIONS:

DEFINITION:

  • Analytical functions compute an aggregate value based on a group of rows. This group of rows are called Window of rows.
  • The Window determines the no of rows to be used to perform the calculation
…