Are subqueries better than joins?

0 Answers  

---

Explain the two type of Cursors ?

8 Answers   Hi Caliber IT,

---

name 3 ways to get an accurate count of the number of records in a table? : Sql dba

0 Answers  

---

How do I send sql query results to excel?

0 Answers  

---

How do I count duplicates in sql?

0 Answers  

---

---

If we have n no of columns in a table, can we add new column in that table with not null constraint?

2 Answers  

---

one of the column in my table contains the data like SAL ---- 1000 1000 2000 3000 3000 So my requirement is i want output like SAL --- 1000 2000 3000 it mean i want to delete duplicate rows only how should u write query?

9 Answers   TCS,

---

What is the difference between delete, truncate and drop command?

0 Answers  

---

Can we create clustered index without primary key?

0 Answers  

---

What is the difference between the conventional and direct path loader? : aql loader

0 Answers  

---

when MSQL8.0 is in market

0 Answers  

---

What are the benefits of pl sql?

0 Answers  

---