Posted by Roy Harvey (SQL Server MVP) on 12/28/07 18:35

On Fri, 28 Dec 2007 10:13:43 -0800 (PST), apatel85@gmail.com wrote:

>Now, I want to filter out duplicates from the dataset and get unique
>records, including all 5 fields.

I'm not at all clear what you are trying for, but perhaps adding
DISTINCT to your query will do it.

Roy Harvey
Beacon Falls, CT

• Next in forum: Re: learner a ms sql
• Prev in forum: Extracting Duplicates from SQL Server 2000
• Thread view: Re: Extracting Duplicates from SQL Server 2000

[Reply to this message]