Write a sql select query that only returns each name only once from a table?

0 Answers  

---

Can there be 2 primary keys in a table?

0 Answers  

---

How do I find duplicates in the same column?

0 Answers  

---

Can we call stored procedure in function?

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,

---

Does inner join return duplicate rows?

0 Answers  

---

what is self join and how it works??

2 Answers   Infosys,

---

what is the difference between the query and corelated query

8 Answers   HSBC, IBM, TCS, Xenosoft,

---

Write a pl/sql script to display the following series of numbers: 99,96,93……9,6,3?

1 Answers  

---

explain the advantages and disadvantages of stored procedure? : Sql dba

0 Answers  

---

How to read xml file in oracle pl sql?

0 Answers  

---

What is the purpose of primary key?

0 Answers  

---