SQL: what is the diff between "any" and "all"

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • bala krishnan
    New Member
    • Oct 2011
    • 1

    #1

    SQL: what is the diff between "any" and "all"

    what is the diff between any & all/
  • ck9663
    Recognized Expert Specialist
    • Jun 2007
    • 2878

    #2
    In what aspect?

    ~~ CK

    Comment

    • Rabbit
      Recognized Expert MVP
      • Jan 2007
      • 12517

      #3
      Any means the condition has to match in at least one instance. All means the condition has to match in every instance.

      Comment

      Working...