How to delete the duplicate records in a table using sql
server
- 4 Answers
- 4116 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 |
can any one urls for learning .net(which is written in simple english)
how can we achieve language interoperability through CLS? How MSIL works?
Explain 'managed' mean in the .NET context
Define a managed code? : Dot net architecture
Explain about validation?
which would be the best to use inproc,outproc or sql server
HI THIS IS THIRUMAL. I AM COMPLETED MY MCA IN 2009 WITH 64%. NOW I AM LOOKING FOR A JOB(FRESHER)IN HYDERABAD.PLEASE IF YOU FIND ANY OPENINGS IN ANY COMPANY SEND IT TO MY MAIL ID PLEASE.. SKILL SET : C,C++,C#.NET,ASP.NET,ADO.NET,SQL SERVER, SSIS,SSRS EMAIL ID : THIRU104@GMAIL.COM THANKS & REGARDS D.THIRUMAL
What is the use of TPL DATAFLOW?
Name some changes done since version 3.0?
Do you know textbox and textview controls of .net mobile? : Microsoft dot net mobile
Describe the advantages of writing a managed code application instead of unmanaged one. What is involved in certain piece of code being managed?
What is boxing and unboxing? Does it occure automaatically or you need to write code to box and unbox?
Dot Net Framework 
