Interested to Buy Any Domain ? << Click Here >> for more details...
How to delete the duplicate records in a table using sql
server
- 4 Answers
- 5535 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / mohamed idhris
SET ROWCOUNT 1
DELETE FROM tbl_name WHERE field_name= 'field_value'
SET ROWCOUNT 0
the above query will delete the duplicate row
| Is This Answer Correct ? | 4 Yes | 2 No |
Answer / rakesh pattajoshi
delete from tbl where id not in(select max(id) from tbl group by name)
| Is This Answer Correct ? | 0 Yes | 0 No |
how to make my form not to appear in the task bar?
I want to create a project like google maps how can we do that with atlas?
Explain hard disk and what is its purpose? : Dot net architecture
Difference between abstract class and interface
100 Answers Accenture, Altruist, Baba Group, CitiGroup, Fiserv, HCL, IBM, iGate, Infosys, Jean Martin, Karthik Industries, Microsoft, OnDLine, TCS,
Will finally block exec if we write an return statement to a try block???????
difference between data reader and dataset
Explain the race around condition? How can it be overcome? : Dot net architecture
What is Opf3
What are relation objects in dataset?
What is a managed code is dim fs as filestreamobject is a managed code? : .NET Architecture
What is .net mobile input validation. : Microsoft dot net mobile
What is code access security (cas)?
Dot Net Framework 
