I would like to retrieve the data in sub query which returns current employees of organisation entity. Main query selects only those persons are present in sub query.

main query : select * from baseEntity where employee in (select employee from organistion which is current);

here i wanted to introduce unique(employee) in sub query. How to acheive this ?