1) how to delete duplicate records from table in sql server
2005

2) what is run time polymorphism

Answer Posted / nkm

SELECT col1,col2 FROM tDupData
GROUP BY col1,col2
HAVING COUNT(*) > 1

Is This Answer Correct ?    4 Yes 14 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

In which format you can pass the value in the sleep function?

548


What are reflections in c#?

491


What is a byte in c#?

555


List the two important objects of ado.net and also list the namespaces that are commonly used in ado.net to aid in connection to a database.

526


Between windows authentication and sql server authentication, which one is trusted and which one is untrusted?

494






How do you specify a custom attribute for the entire assembly (rather than for a class)?

525


Give examples for value types?

493


Explain about CTS?

553


What is difference between asp net and c# net?

489


Can properties be private in c#?

485


what will be the output of the given below coding. using System; public class Exercise { static void OddNumbers(int a) { if (a >= 1) { Console.Write("{0}, ", a); a -= 2; OddNumbers(a); } } public static int Main() { const int Number = 9; Console.WriteLine("Odd Numbers"); OddNumbers(Number); Console.WriteLine(); return 0; } }

3335


How can I access the registry from c# code?

518


What is the difference between field and property in c#?

472


How to sign an assembly with strong name?

583


Can you explicitly call a destructor?

532