How do I find duplicates in sql?

0 Answers  

---

How do rank () and dense_rank () differ?

0 Answers  

---

What is raid? How does it help storage of databases?

0 Answers  

---

i have a table eno dno sal 1 10 200 2 10 150 3 10 100 4 20 75 5 20 100 i want to get sal which is less than the avg sal of thri dept. eno dno sal 2 10 150 3 10 100 4 20 75

12 Answers   IBM,

---

What is partition in sql query?

0 Answers  

---

What is recursive stored procedure?

0 Answers  

---

what is sql optimization

1 Answers   Fidelity,

---

Suppose There is a string A.B....C.......D.........E........F In this string dots (.) are not having fixed count in between of string. I want the output to have string with one dot between. I.e. A.B.C.D.E.F

6 Answers   IBM,

---

What is natural join in sql?

0 Answers  

---

what is the difference between mysql_fetch_array and mysql_fetch_object? : Sql dba

0 Answers  

---

Is it mandatory for the primary key to be given a value when a new record is inserted?

0 Answers  

---

How does a self join work?

0 Answers  

---