Select ename if ename exists more than once.

Jitendrasoft09
Posted by Jitendrasoft09 under Oracle category on | Points: 40 | Views : 819
select ename from emp e group by ename having count(*)>1;

Comments or Responses

Login to post response