How to remove duplicate rows from table?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL Server Interview Questions

What are the restrictions while creating batches in sql server?

0 Answers  


there is a table having two columns no and name and the data is 1 A 2 B 3 C write a query that will result a horizontal output A,B,C

9 Answers   tdfc, vsworx,


How many primary keys are possible in a table?

0 Answers  


Is null in sql server?

0 Answers  


Do you know what is similarity and difference between truncate and delete in sql?

0 Answers  






What is the difference between getdate and sysdatetime?

0 Answers  


can an automatic recovery be initiated by a user? : Sql server administration

0 Answers  


what is an extended stored procedure? Can you instantiate a com object by using t-sql? : Sql server database administration

0 Answers  


create procedure proc1 (@a int) as begin if @a=1 create table #temp(a1 int) else create table #temp(a1 int) end while executeing the above code it shows error like '#temp already exist' .why it shows an error?

8 Answers   IBM,


List out the differences between the clustered index and non-clustered index in sql server?

0 Answers  


What is 2nf normalization form?

0 Answers  


What are date and time data types in ms sql server?

0 Answers  


Categories