OraFAQ Forum: SQL & PL/SQL » Difference between 'exists' and 'in'

Home » SQL & PL/SQL » SQL & PL/SQL » Difference between 'exists' and 'in'

Tue, 12 February 2002 21:06

krishna
Messages: 141
Registered: October 1998

Senior Member

What is the difference in using 'where exists' and 'in' in SELECT queries? Pls let me know at the earliest.
thanks

Tue, 12 February 2002 23:59

pratap kumar tripathy
Messages: 660
Registered: January 2002

Senior Member

Exists-->returns true if subquery returns at least one row
In-->returns true if it is equal to any member of the subquery

Previous Topic:	Difficulty Framing a Query
Next Topic:	string concatenation

Goto Forum:

]

Current Time: Wed Jun 24 12:11:07 CDT 2026