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

Answer / supriya

You want to delete the rows permanently or what

What data type is money?

0 Answers  

---

what is the Dynamic management views? where can you use?

1 Answers   ACC,

---

What is the difference between heap table and temporary table?

0 Answers  

---

A company wants to store their invoices in a database. They already have their customers and articles in that database. Both customer and article are each identified by an unique integer value. Please create the SQL statements for creating the necessary table(s) for storing the invoices in a MySQL database. An invoice should hold information like invoice number, customer, date, article(s) and quantity etc.

1 Answers  

---

What are the advantages of mysql?

0 Answers  

---

How do you start MySQL on Linux?

5 Answers   Cybernet,

---

What are the advantages of mysql in comparison to oracle?

0 Answers  

---

What is the hostname for mysql database?

0 Answers  

---

What are the security alerts while using mysql?

0 Answers  

---

What is foreign key in mysql?

0 Answers  

---

What is Foreign Key? What is the main difference between primary key and Foreign Key ? How Foreign Key can be defined? Is Foreign key is used to join two or more table?

4 Answers  

---

Is postgresql better than mysql?

0 Answers  

---