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