Jump to content

Pl/sql Query Urgent


Recommended Posts

Posted

table for employees .. 3 coulums .. emp id , region , manager id - ref to emp id,
to find out all the employees .. who dont have same region as their manager

Posted

Sel * from Emp a
Inner join Emp b
On a.empid=b.mgrid
And a.rgnid<>b.rgnid

×
×
  • Create New...