What is the difference between IN and EXISTS operators in SQL Server?
IN work like a OR in sql query but in is faster than OR in case of IN server will search whole table EXISTS is use to find the required row and does not search whole table