1) how to delete duplicate records from table in sql server
2005
2) what is run time polymorphism
Answers were Sorted based on User's Feedback
Answer / kishore
select distinct * from Mytable
select distinct * into Newtable from Mytable
drop table Mytable
select * into Mytable from Newtable
Is This Answer Correct ? | 12 Yes | 7 No |
Answer / shailesh
2>Polymorphism is done by two way Overloading and
overriding.Overriding is called the runtime Polymorphism.
Is This Answer Correct ? | 3 Yes | 1 No |
Answer / reva
DELETE FROM tableName WHERE id NOT IN
(SELECT MIN(id) FROM tableName GROUP BY name)
Is This Answer Correct ? | 2 Yes | 2 No |
Answer / nkm
SELECT col1,col2 FROM tDupData
GROUP BY col1,col2
HAVING COUNT(*) > 1
Is This Answer Correct ? | 4 Yes | 14 No |
windows c# using datagridview in edit form sql server
What is class sortedlist underneath?
If a class is a ref type, how we can pass to a function.
wt is namespace? wt is the use?
What is a string in c#?
What is the implicit name and type of the parameter that gets passed into the class set method?
Can a string be null c#?
Why do we need interfaces?
What is null in database?
What is the difference between a function and a method?
Can you drink alcohol with a loop recorder?
What is parameters in c#?