Hi,

I have created a table

CREATE TABLE emp(eno int identity(1,1), eid int)

Inserted values

INSERT INTO emp VALUES (1)

INSERT INTO emp VALUES (2)

INSERT INTO emp VALUES (3)

INSERT INTO emp VALUES (3)

INSERT INTO emp VALUES (3)

INSERT INTO emp VALUES (4)

INSERT INTO emp VALUES (4)

INSERT INTO emp VALUES (4)

INSERT INTO emp VALUES (4)

INSERT INTO emp VALUES (5)

INSERT INTO emp VALUES (5)

INSERT INTO emp VALUES (5)

What i have tried

select max(eid) from emp group by eid having count(eid)>1

not getting desired output.

My result should be like this

eno eid

----------- -----------

3 3

4 3

6 4

7 4

10 5

11 5