Post reply

ROW_NUMBER

  • October 11, 2014 at 1:22 pm

    #75699

    Comments posted to this topic are about the item ROW_NUMBER

  • October 12, 2014 at 11:26 pm

    #1751897

    Easy one...

  • October 13, 2014 at 12:07 am

    #1751899

    Nice question. Thanks for sharing

  • October 13, 2014 at 1:08 am

    #1751908

    Easy enough for a Monday morning 😀

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

  • October 13, 2014 at 1:55 am

    #1751912

    Thank you for the post, Steve, simple one. (for me the choice was obvious, but my uncontrolled mind was still looking for the trick/catch.) 🙂

    ww; Raghu
    --
    The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

  • October 13, 2014 at 2:44 am

    This was removed by the editor as SPAM

  • October 13, 2014 at 3:35 am

    #1751928

    Finally easy 😉

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

  • October 13, 2014 at 4:02 am

    #1751930

    Easy One

  • October 13, 2014 at 5:17 am

    #1751945

    An easy one, yes. But it covers such a powerful piece of functionality. If you don't know windowing functions, it's worth it to take the time to learn them.

    Tally Tables - Performance Personified
    String Splitting with True Performance
    Best practices on how to ask questions

  • October 13, 2014 at 6:08 am

    #1751958

    +1.

    Thanks, Steve.

    ---------------
    Mel. 😎

  • October 13, 2014 at 6:20 am

    #1751962

    The result is undefined without an ORDER BY in the main query. Most likely the results will be sequential by ID.

  • October 13, 2014 at 7:05 am

    #1751973

    Thanks Steve - great question.

    Tally tables and set-based thinking - this should be the first topic users of SQL learn after CRUD when picking up the language. My personal thanks to Jeff Moden for the invaluable insights and instructions on this topic.

  • October 13, 2014 at 7:11 am

    #1751976

    I'm guessing the answer will be correct as long as there are always a minimum of 10 rows in the sysobjects table. Nice question, I seem to use this function quite often.

    Aigle de Guerre!

  • October 13, 2014 at 7:47 am

    #1751985

    Meow Now (10/13/2014)

    I'm guessing the answer will be correct as long as there are always a minimum of 10 rows in the sysobjects table.

    Which, since there are more than 10 system tables will always be the case.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • October 13, 2014 at 7:54 am

    #1751989

    Raghavendra Mudugal (10/13/2014)

    Thank you for the post, Steve, simple one. (for me the choice was obvious, but my uncontrolled mind was still looking for the trick/catch.) 🙂

    Great question and I agree with Raghu. I was waiting for the "got'cha" but couldn't find one.


    Everything is awesome!

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

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