OVER clause enhancement request - ORDER BY for aggregates - by Itzik Ben-Gan

Status : 

  Fixed<br /><br />
		This item has been fixed in the current or upcoming version of this product.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 254387 Comments
Status Closed Workarounds
Type Suggestion Repros 13
Opened 1/28/2007 11:36:50 AM
Duplicates 372548 Access Restriction Public


SQL Server 2005 introduced only partial support for the OVER clause. It is our strong believe that a more complete implementation of the OVER clause should be prioritized highly in consideration for future enhancements in SQL Server. A more complete implementation of the OVER clause can help in solving many common business problems with simpler, more intuitive, and faster solutions than available today and also substantially reduce the need for cursors. 
The following paper details the feature enhancement requests:
The current feedback item addresses the OVER clause enhancement request - ORDER BY for aggregates, discussed in the paper in section 4 item i.
Sign in to post a comment.
Posted by Umachandar [MSFT] on 7/13/2011 at 4:38 PM
Hello Everyone,
Thanks for your feedback. We have now added support for window functions that is compatible with ANSI SQL:2008 standard.
Below are the links to the documentation for latest CTP of SQL Server Denali:


Umachandar, SQL Programmability Team
Posted by WebSolProv on 10/20/2010 at 6:56 AM
Please MS can we have some feedback on the likelihood (and of course, intended release date) for the subsequent version of SQL Server. While SQL 2008 R2 is certainly something to be proud of, it still doesnt really contain these (or anything close) much needed and requested enhancements.
Posted by Maurice Pelchat on 9/24/2010 at 5:28 AM
We have practical cases in applications we develop that would make this features very cool and the SQL code much simpler.

I gave SQL formation to programmers recently about actual SQL windowing functions and some examples about how much they simplify T-SQL querying. However this particular feature can't be reproduced easily to perform well in all cases.
Posted by Microsoft on 9/11/2007 at 4:49 PM
Note: This feedback is for a series of requests for OVER clause enhancement. These items will be looked at both individually and together in future feature design.

This feature unfortunately did not fit into our schedule for SQL Server 2008. Based on customer input, we had prioritized ORDER BY for aggregates and the ROW/RANGE feature, but in the end decided that in order for this feature to be truly useful, we needed to implement more functionality than time would allow. This is a top priority for the next release, and we continue to look forward to great suggestions from you.