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

Is candidate a key?

0 Answers  

What is collation sensitivity? Explain different types.

0 Answers  

What is the process of normalising?

0 Answers  

How to download and install sql server 2005 books online?

0 Answers  

explain the type of contraints

3 Answers  

I have a huge amount of data which is displayed in a report. The data is viewed every day. Every day the data is displayed in 30 secs but suddenly today it is giving an timeout message today. Data has not been changed. The situation is same as yesterday. What might be the reason??? Please Answer.

4 Answers   Satyam,

write the query for find the top 2 highest salary in sql server

36 Answers   Cranes, Jayanti Software, Medi Assist, Rmax, TCS,

What is the distinction amongst delete and truncate?

0 Answers  

write query for fourth maximum salary from employee table

14 Answers   Mind Tree, SP Software,

Do you know how to send email from database?

0 Answers  

What is a domain constraint give an example?

0 Answers  

What is the difference between UNION and UNIONALL?

5 Answers   CarrizalSoft Technologies, CTS,

For more SQL Server Interview Questions Click Here
Categories