Distinct for one column

[David]

I have a query that results 2 columns of data. The first column is ticket
numbers and the second column is an expression. I want to only display the
rows where the expression column is distinct. Any ideas?

Thanks,

Dave

 

[David]

11 Bill
12 Bill
13 Bill
14 Rex
15 Rex
16 John
17 Steve

11 Bill
14 Rex
16 John
17 Steve

or

13 Bill
15 Rex
16 John
17 Steve

 

[David]

I'm sorry I didn't make my last response clear. My boss was flipping out
yesterday.

data in table:
11 Bill
12 Bill
13 Bill
14 Rex
15 Rex
16 John
17 Steve

acceptable output:
11 Bill
14 Rex
16 John
17 Steve

or
acceptable output:
13 Bill
15 Rex
16 John
17 Steve

I basically don't want to display any duplicates in the driver field.

 

[David]

Thanks Karl that worked!

I couldn't get it working properly modify the sql code (im a sql coding
newb). I understood what your code was doing and I went to the builder and
first on the tickets column and then group by on the expression column.
Worked like charm. Thanks again!