Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2005
    Posts
    80

    Unanswered: difference between except and Not exists

    Hi,

    Can any one please tell me the difference between not exists and except clauses in the sql's?

    Thanks,

  2. #2
    Join Date
    Feb 2008
    Location
    Japan
    Posts
    3,483
    EXCEPT compares all (paired)columns of two full-selects.
    NOT EXISTS compares two or more tables accoding to the conditions specified in WHERE clause in the sub-query following NOT EXISTS keyword.

    EXCEPT can be rewritten by using NOT EXISTS.
    (EXCEPT ALL can be rewritten by using ROW_NUMBER and NOT EXISTS.)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •