Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 2 Answers
- 5133 Views
- Sun Life, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How do I fix a crashed mysql database?
What is acid in mysql?
Can we store images in mysql database?
What are the types of database engines available in mysql?
How do I install and use mysql?
How do I delete a mysql user?
Can you tell the reasons for selecting lamp(linux, apache, mysql, php) instead of any other combination of software programs, servers, and operating system?
How can you move the master database
How can you add and remove any column of a table?
How can we convert between Unix & MySQL timestamps?
What is slow query log in mysql?
How to return query output in html format?
How to enter boolean values in sql statements?
What is the use of procedure in mysql?
What are the advantages of myisam over innodb?
