Analytical functions available in SQL Server 2012

  • Junior Galvão - MVP

    SSCertifiable

    Points: 6376

    Comments posted to this topic are about the item Analytical functions available in SQL Server 2012

  • Hany Helmy

    SSChampion

    Points: 13321

    Nice Question, thanx!

  • TomThomson

    SSC Guru

    Points: 104763

    Straightforward question,

    It's a bit surprising how many have it wrong so far (more than half) because the four functions in the three wrong options have all been around since long before 2012.

    Tom

  • patricklambin

    SSCrazy Eights

    Points: 9964

    Nice question on a topic which I have rarely used excepted with my old Developer edition 2008.

    I have only hesitated about CUM_DIST which I have already seen but for 2012 or 2014 ? I was not sure. I attempted this choice successfully.

    Thanks for this point I got ( in a lucky way )

  • Ed Wagner

    SSC Guru

    Points: 286957

    A good, straightforward question and there was no ambiguity. Since I use window functions quite a bit and am still on 2008 for a little while longer, it was simple for me because I know what I don't get to play with and push yet. Thanks.

  • Eirikur Eiriksson

    SSC Guru

    Points: 182344

    TomThomson (5/17/2015)


    Straightforward question,

    It's a bit surprising how many have it wrong so far (more than half) because the four functions in the three wrong options have all been around since long before 2012.

    The ratio is getting better, guess waking up helps:-D

    😎

  • SQLRNNR

    SSC Guru

    Points: 281210

    TomThomson (5/17/2015)


    Straightforward question,

    It's a bit surprising how many have it wrong so far (more than half) because the four functions in the three wrong options have all been around since long before 2012.

    +1

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • akljfhnlaflkj

    SSC Guru

    Points: 76202

    Good question, thank you.

  • Junior Galvão - MVP

    SSCertifiable

    Points: 6376

    Thanks.

  • Junior Galvão - MVP

    SSCertifiable

    Points: 6376

    Hi,

    Yes, you are correct!!!

  • Junior Galvão - MVP

    SSCertifiable

    Points: 6376

    Hi,

    Thanks for comment, the analytical function CUM_DIST has been introduced in SQL Server 2012.

    Regards.

  • Junior Galvão - MVP

    SSCertifiable

    Points: 6376

    Ok, thanks your answer.

  • Junior Galvão - MVP

    SSCertifiable

    Points: 6376

    Hi,

    Thanks, Thanks, I like.

  • Koen Verbeeck

    SSC Guru

    Points: 258907

    Easy one, thanks.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • Arno Kwetters

    Hall of Fame

    Points: 3335

    Nice to know when some features has been added

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

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