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,

---

1. Which is an aggregate function? a. Union b. like c. max d. Rank

1 Answers   Fintellix,

---

What is delete command in sql?

0 Answers  

---

What problem one might face while writing log information to a data-base table in pl/sql?

0 Answers  

---

How can we optimize a sql query?

0 Answers  

---

---

How are sql commands classified?

0 Answers  

---

How do I delete a trigger?

0 Answers  

---

How is a process of pl/sql compiled?

0 Answers  

---

mention if it is possible to import data directly from t-sql commands without using sql server integration services? If yes, what are the commands? : Transact sql

0 Answers  

---

Explain locks? : Transact sql

0 Answers  

---

function can return multiple value?how give give sample coding

2 Answers   3i Infotech, CTS, Excelity Global, UHG,

---

Which tcp/ip port does sql server run on? How can it be changed? : Sql dba

0 Answers  

---