http://www2.sqlblog.com/blogs/adam_machanic/archive/2006/07/12/sql-server-2005-t-sql-aggregates-and-the-over-clause.aspxA new feature added to SQL Server 2005 for the sake of the windowing functions is the OVER clause. Using this clause, you can specify ordering or partitioning for the windowing functions. For instance, to enumerate the names of all of the products inenCommunityServer 2.1 SP2 (Build: 61129.1)http://www2.sqlblog.com/blogs/adam_machanic/archive/2006/07/12/sql-server-2005-t-sql-aggregates-and-the-over-clause.aspx#6290Sun, 20 Apr 2008 06:49:24 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:6290SANJEEV SHARMA<p>I found it very useful. Let me give you a quick overview of the OVER clause. Not very detailed but a will prove a nice kick start for you guys.</p> <p><a rel="nofollow" target="_new" href="http://sanjevsharma.blogspot.com/2008/04/sql-server-2005-over-clause.html">http://sanjevsharma.blogspot.com/2008/04/sql-server-2005-over-clause.html</a></p> http://www2.sqlblog.com/blogs/adam_machanic/archive/2006/07/12/sql-server-2005-t-sql-aggregates-and-the-over-clause.aspx#13542Sat, 25 Apr 2009 16:39:10 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:13542Tinku <p>Thanks a alot very nice information</p> http://www2.sqlblog.com/blogs/adam_machanic/archive/2006/07/12/sql-server-2005-t-sql-aggregates-and-the-over-clause.aspx#34171Tue, 15 Mar 2011 21:27:43 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:34171John Q. Butliquor<p>Nice!</p>