|
View previous topic :: View next topic
|
| Author |
Message |
gcchowdary
Warnings : 1
New User
Joined: 26 Dec 2005
Posts: 18
Location: India
|
|
|
|
If we have two same rows and want to Delete only one row from DB2 table. is it possible thru SQL ? If os please let me know.
Thanks,
G C Chowdary |
|
| Back to top |
|
 |
Bharath Bhat
Active User
Joined: 20 Mar 2008
Posts: 283
Location: chennai
|
|
|
|
People started thinking primary keys are not useful anymore? 
The delete query will delete all the rows matching the where clause. |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hello,
One way to do what you want is with a cursor. . . |
|
| Back to top |
|
|
sachin_star3
Warnings : 1
New User
Joined: 30 Sep 2006
Posts: 78
Location: pune
|
|
|
|
| yes you can use the cursor and can delete the selected row. |
|
| Back to top |
|
|
gcchowdary
Warnings : 1
New User
Joined: 26 Dec 2005
Posts: 18
Location: India
|
|
|
|
| Thank You Dick & Sachin!! |
|
| Back to top |
|
|
|
|
