TOP Clause

  • 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:

  • Tock (5/9/2014)


    Good question and good explanation.

    Steve

    Great question. +1

  • 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.

  • interesting question..

    thanks Nenad.

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

  • Nice question, thanks.

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

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

  • KWymore (5/14/2014)


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

    +1

    Thanks

  • Extremely Easy 🙂

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

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