exists in sql | #sqlstarters

exists
exists will check whether any record is existed in subquery or not

exists will return true if subquery returns one or more records

select name from student where exists (select * from department where dept_id = 5)