Code: Select all
SELECT item FROM table WHERE item_is_not_unique GROUP BY itemModerator: General Moderators
Code: Select all
SELECT item FROM table WHERE item_is_not_unique GROUP BY itemCode: Select all
select item from table where count(item) > 1Code: Select all
column1 | column2
--------+--------
1 | 1
1 | 2
1 | 3
1 | 4
2 | 2
3 | 2Code: Select all
select mytable.* from mytable,(select column2,count(column2) from mytable group by column2) as tableb where tableb.count>1 and dummy.column2=tableb.column2;