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 - 2007-01-23 : 10:06:13
|
| Bob writes "You showed how to remove rows where every column in the row is a duplicate value. What about removing rows where only certain column values are duplicated?For example, let's say I do a SQL query on several tables, and I get the following results:LoanID Borrower TaxID000787 Bob 7567768000898 Tom 9087768000966 Jim 0987765000787 Mary 0998767What if I only want each loanID to appear once in the query results?Thanks,Bob Dickey " |
|
|
readysetstop
Posting Yak Master
123 Posts |
Posted - 2007-01-23 : 14:20:22
|
| So in this case, would you want to remove Bob, or Mary? What criteria would you use to determine which of the duplicate LoanIDs to remove?-D. |
 |
|
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
|
|
|
|
|
Removing duplicates from SQL-Server