Repeated Data

[rahul.kgupta79]

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

how to get only the repeated data from the table

[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);

[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)