T-Virus
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 ;)
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.