| Author: chenna 10 Jul 2006 | Member Level: Silver | Rating:  Points: 2 |
Hi,
SELECT * FROM EMP
WHERE EID IN(SELECT DISTINCT EID FROM PHONE
GROUP BY EID
HAVING COUNT(*) >= 2)
OR
SELECT EMP.* FROM EMP E, PHONE P
WHRE E.EID = P.EID
GROUP BY E.EID, E.ENAME, E.ESAL
HAVING COUNT(*) >= 2
Thanks and Regards
-Kesav
|
| Author: divya 13 Oct 2008 | Member Level: Gold | Rating: Points: 1 |
select a.id from test a where a.id in(select b.id from test1 b group by b.id having count(*)>=1)
|
| Author: Mahima Nayak 28 Oct 2008 | Member Level: Bronze | Rating: Points: 4 |
SELECT eid, ename
FROM emp
WHERE (eid IN
(SELECT eid
FROM phonenumber
GROUP BY eid
HAVING (COUNT(*) >= 2)))
|
| Author: T.Thirumala Reddy 07 Nov 2008 | Member Level: Bronze | Rating: Points: 1 |
select * from emp
where eid=(select distinct eid from phone group by eid having(count(*)>1))
|
| Author: Deepika Haridas 22 Nov 2008 | Member Level: Diamond | Rating: Points: 2 |
SELECT EMP.* FROM EMP E, PHONE P WHRE E.EID = P.EID GROUP BY E.EID, E.ENAME, E.ESAL HAVING COUNT(*) >= 2
|
| Author: Deepika Haridas 26 Nov 2008 | Member Level: Diamond | Rating: Points: 2 |
SELECT eid, ename
FROM emp
WHERE (eid IN
(SELECT eid
FROM phonenumber
GROUP BY eid
HAVING (COUNT(*) >= 2)))
|