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 >> MySQL
  2. Suggest New Category

I want to make a query where I want to eliminate the
duplicate rows from the table.
For example :
Input : Table : NAME
Column1 Column2
India USA
USA India
UK India
India UK

The desired output that I want to eliminate the duplicates
Output
India USA
UK India
Thanks

Question Posted / venom

Answers were Sorted based on User's Feedback



I want to make a query where I want to eliminate the duplicate rows from the table. For example :..

Answer / bramhendra kumar

CREATE TABLE #TBLD (NAME VARCHAR(20),NAME2 VARCHAR(20))
INSERT INTO #TBLD VALUES('India','USA'),('USA','India'),('UK', 'INDIA'),('India','UK')
WITH CTE
AS
(
SELECT *, ROW_NUMBER() OVER (PARTITION BY NAME ORDER BY NAME) AS ROWNUM1,
ROW_NUMBER() OVER (PARTITION BY NAME2 ORDER BY NAME2) AS ROWNUM2
FROM #TBLD
)
DELETE FROM CTE WHERE ROWNUM1>1 OR ROWNUM2>1

SELECT * FROM #TBLD

TRUNCATE TABLE #TBLD

Is This Answer Correct ?    0 Yes 0 No

I want to make a query where I want to eliminate the duplicate rows from the table. For example :..

Answer / supriya

You want to delete the rows permanently or what

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More MySQL Interview Questions

How to create a trigger in mysql?

0 Answers  

How to get current MySQL version?

0 Answers  

What is mysql command line?

0 Answers  

How many sql ddl commands are supported by 'mysql'?

0 Answers  

HOW TO FIND display the total number of weeks in the year of 1998 IN EMP TABLE

0 Answers  

How do I show all mysql databases?

0 Answers  

What is mysql and why it is used?

0 Answers  

How does php communicate with mysql?

0 Answers  

How to enable or disable a row of a table using MySQL in struts?

0 Answers  

What are some good ideas regarding user security in MySQL?

2 Answers  

How can you get your MySQL root password, if you lost it?

1 Answers   PCS,

What are the 3 main types of search queries?

0 Answers  

For more MySQL Interview Questions Click Here
Categories