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

write a query to remove duplicate records without using primary key column?

Question Posted / mathanrathinam

Answers were Sorted based on User's Feedback



write a query to remove duplicate records without using primary key column?..

Answer / 312

351

Is This Answer Correct ?    3 Yes 3 No

write a query to remove duplicate records without using primary key column?..

Answer / mathanrathinam


delete tmp from(select col1,col2,row_number over(partition by col1,col2 order by col1,col2) rownum from tablename) tmp
where rownum >1

Is This Answer Correct ?    7 Yes 8 No

Post New Answer

More SQL Server Interview Questions

What is difference between drop truncate and delete?

0 Answers  

How to use clusters?

0 Answers   Amdocs,

Explain indexed view?

1 Answers  

What language is sql server written in?

0 Answers  

What are scheduled tasks in sql server?

0 Answers  

How to handle error or exception in sql?

0 Answers  

What are the operating modes in which database mirroring runs?

0 Answers  

can you any body tell me why are go for the rebuild the master database.what is the reason?

2 Answers  

What is query optimization process?

0 Answers  

can any one post me, how to remove rows in the below table ENO ENAME EDEPT ELOC 3368 BPS BI Adayar 3371 RAN BI valachari 3369 SRI BI valachari 3372 jay BI Chn - - - - - - - -

2 Answers  

What is cursors? And what are the different types of cursor?

0 Answers  

What are user-defined functions (udfs) in sql server?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories