Re: how to sort data and remove dups

You can get the duplicate records like this:

with dupes as (
select key1, count(*)
from thefile
group by key1
having count(*) > 1
)
select *
from thefile
where key1 in
(select key1 from dupes)

I'm not sure what you mean by data reduction, so this may not be what you want.


On 4/30/2013 4:19 PM, Stone, Joel wrote:

For testing, what is a simple and quick method of sort & data reduction by removing dup records?

I thought of TAATOOLS SORTDB but there is no data reduction option.

Is SQL distinct going to be the ticket?

Thanks!



______________________________________________________________________
This outbound email has been scanned for all viruses by the MessageLabs Skyscan service.
For more information please visit http://www.symanteccloud.com
______________________________________________________________________