Member Avatar for balakrishnan.kb

hi

what is difference between NOT EXISTS and NOT IN and also EXISTS and IN at subquery

thanks

  • 3 Contributors
  • 2 Replies
  • 115 Views
  • 1 Week Discussion Span
  • Latest Post Latest Post by shrichandray
Member Avatar for debasisdas

what did google say ?

Member Avatar for shrichandray

hi

what is difference between NOT EXISTS and NOT IN and also EXISTS and IN at subquery

thanks

If you did not get your answer yet, then let me try to answer it in a brief...
Not Exists Check for one occurance in the Sub query and comes out and to use Not Exists you have to user subquery or co-related query.
Where in case of t Not In it chekc the condition again the set of values specified or returned by sub query....
If you can use Not eixts it is always better for performance...

:)

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.