Repeated Data

[krishnaindia2007]

table:dept field: department values: sales sales marketing reporting revenue revenue how to get only the repeated data from the table

select department from dept where rowid in (select min(rowid) from dept group by department);