Aggregate window functions are used to perform operations on sets of rows in a window(s). They include SUM() , MAX() , COUNT() , and others. Rank window functions are used to rank rows in a window(s).

I'm trying to come up with a query format that will allow me to return multiple rows of aggregate data grouped by DATE, but the date values would be BETWEEN certain intervals.As in, the data would ...

Topic says it all. Anyone know the best way to write a median aggregate function in ms sql server 2k? I've seen a couple ways of doing it when I briefly searched google but they weren't presented ...