Posted by dale.zjc on 04/10/06 23:02

I've got the following table data:

11652 5.99
11652 0.14
12996 5.03
12996 0.12
12996 7.00

And I need to write a query to return only rows 2 and 4, since the
remaining rows have duplicate IDs. I've tried the Group By, but am
having no luck.

Thanks!

• Next in forum: Re: Remove Duplicate Rows
• Prev in forum: Re: Re-display result set without re-running query in Query Analyzer?
• Thread view: Remove Duplicate Rows

[Reply to this message]