Answer / Manish Kumar Dwivedi

You can use a subquery to find duplicates in multiple columns. For example: SELECT column1, column2 FROM table WHERE (column1, column2) IN (SELECT column1, column2 FROM table GROUP BY column1, column2 HAVING COUNT(*) > 1).

explain the delete statements in sql

1 Answers  

---

what are string data types? : Sql dba

1 Answers  

---

What are different types of functions in sql?

1 Answers  

---

How do I make my sql query run faster?

1 Answers  

---

wirte a query to remove null? following table are col1 col2 col3 dinesh null null null suresh null null null prakesh i want the output like col1 col2 col3 dinesh suresh prkaesh

6 Answers   TCS,

---

can we update a view which is created from two tables

11 Answers  

---

Is pl sql a programming language?

1 Answers  

---

What is the use of triggers?

1 Answers  

---

What is a temporal table?

1 Answers  

---

Can we interchange parameters in procedure while calling

1 Answers   TCS,

---

How to process query result in pl/sql?

1 Answers  

---

Why we use pl sql?

1 Answers  

---