I'm trying to query the contents of a table based on the combination of 2
columns being distinct.
So far I have
SELECT DISTINCT
ColB, ColC
FROM table_1
This query pulls the rows I'm looking for,
but now how do I get all the other columns that are in the table?
I'm trying to get ColA, ColB, ColC, ColD, ColE.
I tried
SELECT *
FROM table_1
WHERE EXISTS (
SELECT DISTINCT
ColB, ColC
FROM table_1)
But this returns every row.
Any suggestions?
Matt
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
