I want to make a query where I want to eliminate the
duplicate rows from the table.
For example :
Input : Table : NAME
The desired output that I want to eliminate the duplicates
Answers were Sorted based on User's Feedback
Answer / bramhendra kumar
CREATE TABLE #TBLD (NAME VARCHAR(20),NAME2 VARCHAR(20))
INSERT INTO #TBLD VALUES('India','USA'),('USA','India'),('UK', 'INDIA'),('India','UK')
SELECT *, ROW_NUMBER() OVER (PARTITION BY NAME ORDER BY NAME) AS ROWNUM1,
ROW_NUMBER() OVER (PARTITION BY NAME2 ORDER BY NAME2) AS ROWNUM2
DELETE FROM CTE WHERE ROWNUM1>1 OR ROWNUM2>1
SELECT * FROM #TBLD
TRUNCATE TABLE #TBLD
|Is This Answer Correct ?||0 Yes||0 No|
Answer / supriya
You want to delete the rows permanently or what
|Is This Answer Correct ?||0 Yes||1 No|
What is a data directory?
How MySQL Optimizes DISTINCT?
Is null in mysql?
Where is the mysql config file?
maximum database size of mysql database
Is mysql a server?
What is required to create mysql database?
What are the different tables present in MySQL?
how can you test for null values in a database? : Mysql dba
How can you validate emails using a single query?
How do I stop a mysql service?
What could be the reason that the mysql statement 'select avg (salary) from emp' generates an inaccurate output?