Multiple Distinct

[Aspears]

I have a table that looks like the following:

Machine Date

N202019 9/16/2006
N202019 9/14/2006
N202019 9/16/2006
N202019 9/16/2006
N202019 9/14/2006

I only want to get the rows that have a Distinct Machine and Distinct Date. Should only show 2 rows in this example.

Thanks for your help

 

[LarrySteele]

The following will give you just two rows from your values:
[tt]select distinct
machine, date
from {table name}[/tt]

HTH,
Larry