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 |
|
Sonu619
Posting Yak Master
202 Posts |
 Posted - 2013-05-21 : 23:28:34
|
| Hi Guys, How i can below data.Here is sample data.ID VALUE MVAL VALUE OCome1 First 141 1 41 First 141 1 4Thank You. |
|
|
MuMu88
Aged Yak Warrior
549 Posts |
Posted - 2013-05-21 : 23:38:16
|
| If you mean to say how to delete duplicate entries:Here is a way to do it:[CODE]DELETE tFROM(SELECT ROW_NUMBER() OVER (PARTITION BY id, value, mval, value, ocome ORDER BY id) AS Seq,*FROM Table)tWHERE Seq > 1[/CODE] |
 |
|
|
Sonu619
Posting Yak Master
202 Posts |
Posted - 2013-05-21 : 23:46:22
|
| Thanks. Thats what i want... |
|
|
|
|
|
|
Delete help