IN : We will use this IN operator if we want to find out a value in a list of values. EXIST : We will use exist operator when we want to find out a value from Result of the sub query.