Can we have WHERE CLAUSE in SELF JOIN?

Answer:

Yes. We can write Where Clause in Self Join. As self join joins table itself. So it will produce result based on condition,which we supply in where clause.

For example:-

Select * from employee_master a,employee_master b where a.employee_id = b.employee_id;