-
What is the best way to achieve the following?.
I want to, select the value of COL1 from TAB1, if there is duplicate value for COL1, COL2, COL3 combined.
I have the following qry, but believe there would be some better ones.
Select COL1 from (
Select COL1, COL2, COL3, COUNT(*)
From TAB1
Group by COL1, COL2, COL3
Having COUNT(*) > 1 )
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|