Difference between EXISTS and IN in SQL?

asked17 years ago
last updated3 years ago
viewed624.6k times
Up Vote498Down Vote

What is the difference between the EXISTS and IN clause in SQL?

When should we use EXISTS, and when should we use IN?