To find all names who have same salry of eid=10

create table emp(eid int,ename varchar(20),esal money)

insert into  emp values(10,'Raju',200)

insert into  emp values(20,'ramu',200)

insert into  emp values(30,'muttu',300)

insert into  emp values(40,'vikarm',400)

insert into  emp values(50,'vina',500)

insert into  emp values(60,'guru',200)

select * from emp

--To find all names who have same salry of eid=10

select e2.eid,e2.esal,e2.ename  from emp e1,emp e2

where e1.eid=10 and e2.esal=e1.esal