August 30, 2008 04:19am pdt

1. angelIII 10,750
2. DanielWilson 10,560
3. it-dept 4,100
4. dbaduck 4,000
5. Ha11y 3,700
6. matrixnz 3,200
7. dqmq 3,000
8. Binuth 2,800
9. chapmandew 2,500
9. b0lsc0tt 2,500
11. frankytee 2,000
11. wmeerza 2,000
11. mwvisa1 2,000
11. EugeneZ 2,000
11. matty1stop 2,000
11. Rrooter 2,000
11. Yiogi 2,000
11. drequinox 2,000
11. Joe_Woo... 2,000
11. ee_rlee 2,000
11. JezWalters 2,000
11. IdoMillet 2,000
11. KICUSek 2,000
11. routinet 2,000
25. Kdo 1,750

1. DanielWilson 29,435
2. angelIII 25,850
3. it-dept 6,100
4. dqmq 6,000
5. appari 4,000
5. sujith80 4,000
5. dbaduck 4,000
8. Ha11y 3,700
9. matrixnz 3,200
10. acperkins 3,000
10. routinet 3,000
10. samtran0... 3,000
10. xDJR1875 3,000
14. Binuth 2,800
15. b0lsc0tt 2,500
15. ptjcb 2,500
15. chapmandew 2,500
18. SysExpert 2,000
18. DaVinci007 2,000
18. matty1stop 2,000
18. Mikal613 2,000
18. Joe_Woo... 2,000
18. Yiogi 2,000
18. mankowitz 2,000
18. jwahl 2,000
18. DocGyver 2,000
18. dready 2,000
18. frankytee 2,000
18. EugeneZ 2,000
18. johnsone 2,000
18. Rrooter 2,000
18. paquicuba 2,000
18. mwvisa1 2,000
18. LPurvis 2,000
18. mfsamuel 2,000
18. ee_rlee 2,000
18. dreamyguy 2,000
18. sasmeister 2,000
18. _agx_ 2,000
18. FixingStuff 2,000
18. AlexShipov 2,000
18. Kaviyaras... 2,000
18. itpuzzleso... 2,000
18. PFrog 2,000
18. wmeerza 2,000
18. dduser 2,000
18. KICUSek 2,000
18. TechSoEasy 2,000
18. jimpen 2,000
18. NJComput... 2,000
18. Swindle 2,000
18. Yurich 2,000
18. JezWalters 2,000
18. TommyTupa 2,000
18. IdoMillet 2,000
18. aneeshatti... 2,000
18. drequinox 2,000
18. fenety 2,000

07.02.2007 at 12:00AM PDT, ID: 22669984

	[x] Attachment Details

how to eliminate duplicates from a multi-column query

Asked by WmRichard in SQLBase, PL / SQL

Tags: eliminate, duplicates, query, column

How does one eliminate duplicate rows from a query?

One of the columns has many duplicate values. I require to pull all the table A rows with the exception of Table A's column col2 contains no duplicates. The actual table is around 15 million rows.

For example,
select col1, col2, col3, col4 from table A (where col2 is distinct) --semi-psuedo codeStart Free Trial

Keywords: how to eliminate duplicates from a multi…

	Title
1	Return entire row for Distinct COL1 w…
2	Where (Col1, Col2) in (select...
3	Updating million records, how to optim…
4	Select Distinct
5	Distinct concatenated null fields
6	SELECT DISTINCT issue

Loading Advertisement...

20080716-EE-VQP-32

how to eliminate duplicates from a multi-column query

Asked by WmRichard in SQLBase, PL / SQL

Tags: eliminate, duplicates, query, column

About this solution