Please Solve this SQL Query

[Care Career]

Hi Everyone Two Tables r there. Emp-ENO->1,2,3 Ename->A,B,C Score-ENO->1,2,3 S1->70,96,80 S2->75,65,75 S3->90,,100 In Score Table fields ENO,Subject1,S2,S3 r there shown above. Please help.I want to display those employee names who got same marks in Subject 2 like 75 in S2. Please help for this query. Thanks CARECAREER

[Krish KP]

check whether this solvs select * from score where s2 in ( select s.s2 from emp e inner join score s on e.id = s.id group by s.s2 having count(*) > 1 )

Regards KP