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 - 2005-05-26 : 08:13:28
|
| Anantha writes "I have a question on how to eliminate duplicate records in my query.Right now I have some Tests (tests table)say T1,T2,T3 whose requirements are say R1(requirements table) which exists in all tests T1,T2,T3. Both these tables are joined by test id to reqt idT1 - R1T2 - R1T3 - R1Since same requirement exists in all tests which is duplication of data,I now need to keep only one test(either T1 or T2 or T3) with reqt R1. Can you tell me how do I query to eliminate this duplication?" |
|
|
Amethystium
Aged Yak Warrior
701 Posts |
Posted - 2005-05-26 : 08:48:44
|
you can either use the DISTINCT keyword here or UNION the results.------------->>> BREAKING NEWS!!! <<<------------- Saddam Hussien has weapons of mass destruction |
 |
|
|
|
|
|
Question on eliminating duplicate