Link to home
Start Free TrialLog in
Avatar of T-Virus
T-VirusFlag for Netherlands

asked on

Challenge: Best performing Query to find duplicates

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 ;)
ASKER CERTIFIED SOLUTION
Avatar of Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3]
Flag of Luxembourg image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial