AVG: Returns the average value of a numeric column. COUNT: Returns the number of rows that match a specified condition. MAX: Returns the maximum value in a set of values. MIN: Returns the minimum ...
I want to design a query to compute some returns for stock data and in searching the 'SQL Server Books Online' I find a very small and not so helpful at all help section on the lead and lag functions.