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

How do I import database through command line?

1013

---

How do I change directories in mysql?

915

---

What is the difference between unix timestamp and mysql timestamp?

1061

---

Explain the difference between procedure and function in mysql?

1001

---

Transactions are used to treat sets of SQL statements atomically. State Whether True or False?

1463

---

Can we write pl sql mysql?

953

---

What are the technical features of MySQL?

1013

---

can you tell how can you display the maximum salary in sql? : Mysql dba

869

---

Explain % and _ inside like statement?

1021

---

How do I disconnect mysql workbench?

1071

---

What is a data directory?

953

---

How to make a copy values from one column to another in mysql?

1041

---

How can I create a database in mysql?

877

---

Can I copy mysql data directory?

934

---

Can u give the example by taking an unnormalized table and make that 1nf and then 25nf, and then 3 nf?

4681

---