Repeated Data

table:dept
field: department
values: sales
sales
marketing
reporting
revenue
revenue

how to get only the repeated data from the table

[quote=rahul.kgupta79;28292]table:dept field: department values: sales sales marketing reporting revenue revenue how to get only the repeated data from the table[/quote] select department from dept where rowid in (select min(rowid) from dept group by department);

[QUOTE=rahul.kgupta79;28292]table:dept
field: department
values: sales
sales
marketing
reporting
revenue
revenue

how to get only the repeated data from the table[/QUOTE]
Try this
select distinct department from dept where department in (select department from dept having count(*)>1 group by department)