A. Retrieves the previous value in a result set based on a specified order
B. Returns the next value in a result set based on a specified order
C. Calculates the average value for each group of rows
D. Counts the number of rows in a result set

Solution

A. Retrieves the previous value in a result set based on a specified order