Get duplicate record from table

Get duplicate records from table
Select ename from tbemp a where a.eno!=(select Max(eno) from tbemp b where a.ename=b.ename)

Here eno denotes to employee number and ename denotes to employee name.