Question: I am trying to select 3 columns from a table based on the first 2 columns (as a group) only having a `count = 1`. Once they have been identified i would like to bring in the 3rd column of that row.

This statement works for the first 2 columns but i can't add the 3rd column as i don't want the search group to be defined by this.

```
SELECT
  Defect_Point,
  Report_Num
FROM MyCount
GROUP BY Defect_Point,
         Report_Num
HAVING COUNT(*) = 1

```

Any Ideas where to go from here?

Answer: 
If I understand right, you could use the over clause and a subquery to achieve what you want.

```
SELECT * FROM
(
Select
  Defect_Point, Report_Num, Third_Column,
  COUNT(*) OVER(PARTITION BY Defect_Point, Report_Num) AS your_count
from MyCount
) a
WHERE your_count = 1;

```
You can try following also:

```
select 
  contact_uid, 
  group_uid 
from 
  relation;

```

(12 56), 
(15 56)
(15 57),
(12 55),
(12 56)

```
SELECT
  contact_uid,
  group_uid
FROM relation
WHERE group_uid IN (SELECT
  group_uid
FROM relation
GROUP BY group_uid
HAVING COUNT(*) = 1);

```

Sorry, don't know how to beautify that but those are the values of columns contact uid and group uid.