Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-01-18 : 08:30:03
|
Bob writes "Thank you so much for providing this service. I've got a table that I know has duplicate rows. However, using the examples from the Books online yeilds either all rows or no rows.
I run a query that goes something like this:
Select (insert all rows in the table)
from (table name, of course)
group by (all rows in the table)
having count (*)>1
this query yeilds no results. What am I missing here?
If I can figure out a query that will return just the dupes, how will permanently eliminate them?
Thank you for any help you can give.
Bob
SQL 7 w/ sp2" |
|
|
|
|
|
Eliminating Duplicate Rows