Repeated Data

[susarlasireesha]

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

how to get only the repeated data from the table

Try this
select distinct department from dept where department in (select department from dept having count(*)>1 group by department)