What database? If it's SQL Server, NOT IN might do the job.
- Tom
Quote:
> I am trying to do something like this...
> "SELECT NOT DISTINCT {*filter*}.NDC FROM {*filter*}"
> The above statement of course gives me an error. What I am trying to do is > filter out the non-unique values from a table that has over 150,000 records > in it. Does what the best SQL statement would be to accomplish this?
> Thanks in advance.
> Lowry
Mon, 22 Sep 2003 01:48:38 GMT
J Lowry Sno #2 / 2
Not Distinct SQL Query
I am trying to do something like this...
"SELECT NOT DISTINCT {*filter*}.NDC FROM {*filter*}"
The above statement of course gives me an error. What I am trying to do is filter out the non-unique values from a table that has over 150,000 records in it. Does what the best SQL statement would be to accomplish this?
Not Distinct SQL Query