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

how to get only the repeated data from the table