Specific Duplicate Records - SQL Server Forums

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.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

Specific Duplicate Records

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-04-09 : 18:17:14

David writes "I have a table with 5 columns........
there is no primary keys...........
I need to know the duplicate records based on all but 1 of the fields.( the last field) for example

column 1  column 2   column 3  column 4  column 5
one          two       three     four      five
one           two       three     four      eight

so this would be a dupe record............but my main problem is I have to present the info like this

column 1  column 2   column 3  column 4  column 5
one          two       three     four      five
one           two       three     four      eight

I have to show both records, even the field that does not need to be a dupe..............Please help"

yakoo
Constraint Violating Yak Guru

312 Posts

Posted - 2002-04-09 : 20:51:32

Sounds either like a repost or a "homework" assignment.

Take a look at http://www.sqlteam.com/Forums/topic.asp?TOPIC_ID=14756

Nazim
A custom title

1408 Posts

Posted - 2002-04-10 : 00:30:01

you can read this article Graz wrote on Deleting Duplicate record http://www.sqlteam.com/item.asp?ItemID=3331.

--------------------------------------------------------------

rrb
SQLTeam Poet Laureate

1479 Posts

Posted - 2002-04-10 : 04:27:27

quote:

Sounds either like a repost or a "homework" assignment.

I'm betting "homework" assignment

- be sure and let us know what grade you get

--
I hope that when I die someone will say of me "That guy sure owed me a lot of money"

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources