I liked this query a lot so i wanted to remember it.It's simple but pretty cool:select column, count(column) as numfrom tablegroup by column having num > 1;