What is the difference between ‘any’, ‘all’ and ‘exists’ in SQL?

Any,all and exists are subqueries in SQL.

Any is used when 1 or more records match the sub condition and the result is true for those records.

All is used when all the records match the sub condition thus we get the output to be true else false.

Exists is same as any except for the time consumed will be less as, in ANY the query goes on executing where ever the condition is met and gives results . In case of exists it first has to check throughout the table for all the records that match and then execute it.