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 |
|
rexyrexin
Starting Member
19 Posts |
 Posted - 2011-09-21 : 14:11:40
|
| I have a table, EMP.EMP-----Empid EmpName City nuumber------------------------------------------------1 rahul noida 3212 abhi noida 9873 dippy noida 1234 tom noida 1 rahul 321Now I want to delete duplicate rows which have same empid but have less data in their columns than the other one. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
rexyrexin
Starting Member
19 Posts |
Posted - 2011-09-21 : 21:00:23
|
| I have two rows having same data i.e. empid. But one row has one column missing . So I want to delete that row only. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
rexyrexin
Starting Member
19 Posts |
Posted - 2011-09-22 : 08:04:56
|
| Thanks for replying. I have done using Rank() |
|
|
|
|
|
|
Delete duplicate data