| 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
Thanks & Regards,
Deepika
Editor
If U want to shine like a SUN..First U have to burn like the SUN!!
Need a Guide? Join my mentor program..
|
| 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)))
Thanks & Regards,
Deepika
Editor
If U want to shine like a SUN..First U have to burn like the SUN!!
Need a Guide? Join my mentor program..
|