TOP Clause

• sql Sarah

  SSCrazy

  Points: 2081

  More actions

  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:

• Hany Helmy

  SSChampion

  Points: 13921

  More actions

  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

• Hany Helmy

  SSChampion

  Points: 13921

  More actions

  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

• PChiragS

  SSCarpal Tunnel

  Points: 4965

  More actions

  May 10, 2014 at 7:44 pm

  #1712426

  interesting question..

  thanks Nenad.

• phil121

  SSC Rookie

  Points: 36

  More actions

  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:

• free_mascot

  One Orange Chip

  Points: 27164

  More actions

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

• Ken

  SSCoach

  Points: 17191

  More actions

  May 14, 2014 at 2:52 pm

  #1713630

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

• Hardy21

  SSCrazy Eights

  Points: 9708

  More actions

  May 15, 2014 at 4:16 am

  #1713763

  KWymore (5/14/2014)

  ---

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

  +1

  Thanks

• Mr. Kapsicum

  SSCertifiable

  Points: 6128

  More actions

  June 2, 2014 at 1:46 am

  #1718119

  Extremely Easy