Hi,
10 sunil S/E
20 ravi T/E
30 naga S/E
40 john T/E
10 steven S/E
30 ravi T/E
I need ouput as,
10 sunil S/E
10 steven S/E
30 naga S/E
30 ravi T/E
Hi,
10 sunil S/E
20 ravi T/E
30 naga S/E
40 john T/E
10 steven S/E
30 ravi T/E
I need ouput as,
10 sunil S/E
10 steven S/E
30 naga S/E
30 ravi T/E
SELECT
t1.id
, t1.name
, t1.whatever
FROM tablename AS t1
INNER JOIN
(SELECT id
FROM tablename
GROUP BY id
HAVING COUNT(*) > 1
) AS t2
ON t1.id = t2.id