I once a week challenge myself to find new ways of doing things.
Maybe u guys want to jump in on the game. ;)
Here ist the challenge.
You have to find a query that will return all duplicates in a Table, you have to use (*) in your select and it is not allowed to use group by!
Best performing, easiest to write query wins the price ;)