Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

how to delete duplicate rows from table in sql server

Question Posted / k l baiju

Answers were Sorted based on User's Feedback



how to delete duplicate rows from table in sql server..

Answer / suresh s

delete tblname where columname in (select columnname
FROM tblname GROUP BY columnname having count(columnname)
>=2)

Is This Answer Correct ?    25 Yes 30 No

how to delete duplicate rows from table in sql server..

Answer / swapna

We can delete duplicate rows from table by using distinct
command.

Is This Answer Correct ?    10 Yes 35 No

Post New Answer

More SQL Server Interview Questions

What is RAID? What are the different types of RAID configurations?

0 Answers   Flextronics,

How can you start sql server in different modes?

0 Answers  

explain what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration

0 Answers  

We need to perform what steps in the following order to work with a cursor?

0 Answers  

What is cte (common table expression)?

0 Answers  

sql server syntax to add "!" sign to "name" field of "employee" table in a manner that all names have the same lenght of 20 characters

1 Answers  

What is a primary key?

0 Answers  

how do we insert 100 records at a time in a table without using for loop in database

1 Answers  

What are pessimistic lock and optimistic lock?

0 Answers  

Define self join in sql server joins?

0 Answers  

Detail about the hardware which is supported by SQL server?

0 Answers  

What is dbcc?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories