What is Exists Operator in SQL?

 Exists Operator :

>> A subquery with exists does not really return any data; it returns TRUE or FALSE.
>>This operator performance is very high compared to the “IN” operator.
>>Always exist operator start searching mechanism when child query return true.
>>It cannot compare direct values . It should have a subquery with Select.
>>SQL Engine stops process as soon as finding a single condition in EXISTS.
#tipsandtricks #SQL#DATA #oracle #analytics