Post reply

TOP Clause

  • May 9, 2014 at 12:18 pm

    #1712295

    The database I was running against has SQL 2000 compatibility. So I had to change the insert statements to use Selects and Unions....

    Oh I just figured it out. I used Union instead of Union ALL...

    I updated the query and now it returns 8. :blush:

  • May 10, 2014 at 4:42 am

    #1712379

    Tock (5/9/2014)

    Good question and good explanation.

    Steve

    Great question. +1

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

  • May 10, 2014 at 4:45 am

    #1712380

    nenad-zivkovic (5/8/2014)

    Comments posted to this topic are about the item <A HREF="/questions/Top/107321/">TOP Clause</A>

    Agree with the explanation about the forgotten features for TOP clause & WITH TIES option,

    thanx Nenad.

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

  • May 10, 2014 at 7:44 pm

    #1712426

    interesting question..

    thanks Nenad.

  • May 12, 2014 at 12:12 pm

    #1712815

    Always good to learn something new. Thanks! The day I quit learning is the day I begin to be useless.:w00t:

  • May 13, 2014 at 11:16 pm

    #1713312

    Nice question, thanks.

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

  • May 14, 2014 at 2:52 pm

    #1713630

    Nice question. I forgot all about the WITH TIES option.:-)

  • May 15, 2014 at 4:16 am

    #1713763

    KWymore (5/14/2014)

    Nice question. I forgot all about the WITH TIES option.:-)

    +1

    Thanks

  • June 2, 2014 at 1:46 am

    #1718119

    Extremely Easy 🙂

Viewing 9 posts - 16 through 23 (of 23 total)

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