SQL if Condition

i want to use the if condtion like in MS-SQL like
if exist(select * from emp)
insert into…….
else
messege(‘no data found’)

same like this can we compare direct select statment in if condition, plz any idea, explain with syntex example.