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 |
|
RoniDxb
Starting Member
28 Posts |
 Posted - 2008-08-03 : 19:44:49
|
| Table1 A......B...................................1......Mouse................................2......Keyboard.............................3......Printer..............................2......Keyboard.............................1......Mouse................................1st . I want to select all those rows which are duplicate for example in Table1 it will be like1......Mouse................................1......Mouse................................2......Keyboard.............................2......Keyboard.............................2nd.Select all those rows which are not duplicate for example in Table1 it will be like3......Printer..............................plz guide me |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
How can we select duplicate rows in a table