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-11-05 : 00:13:25
|
| Prithvi writes "HiI need a SQL query that fetches all the rows under following situation:There is a table with 12 fields say a,b,c...I need all the records in which if (record1.a = record2.a and record1.b= record2.b)To be more clear I need all the records with duplicate records with a special condition. Duplicate records are ok in my table but two records cannot have same combination of duplicate values.Example - Name and initial:I can have duplicate names and duplicate initials but not bothI'm finding it difficult to form a query and there are more than 15000 records.Please respond.Thankx in advancePrithvi" |
|
|
|
|
|
Find duplicate records - 2 columns identical