Post reply

What are windowed function?

  • April 27, 2009 at 10:57 pm

    #202631

    I have heard this term and does not read it before for any function type. So could some one tell me that what are windowed functions in T-SQL?

    DBDigger Microsoft Data Platform Consultancy.

  • April 28, 2009 at 1:49 am

    #984875

    Window functions in SQL Server 2005 have nothing to do with Microsoft Windows; rather, they create data windows. Window functions enable you to look at different levels of aggregation all at once, making it very easy to retrieve cumulative sums, move averages, and perform other calculations.

    Useful Link with Samples on Same :

    http://www.sqljunkies.com/HowTo/4E65FA2D-F1FE-4C29-BF4F-543AB384AFBB.scuk

    -:-)

    Cheer Satish 🙂

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply