Results 1 to 2 of 2

Thread: Exists & in

  1. #1
    Join Date
    Aug 2010

    Unanswered: Exists & in

    Hi every one . what is different between EXISTS & IN for use in select commands

  2. #2
    Join Date
    May 2003
    EXISTS usually refers to a subselect that either ruturns a single value (of any kind) or a null value (not exists). Did you check the SQL Reference Vol 1 manual to see if they had examples?
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

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