Types of optimization?

6 Answers   Microsoft,

---

What does “select count(1) from tab” result?

10 Answers   IBM,

---

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 a sub query?how will you calculate working days in a month using sub query?

4 Answers   InteQ,

---

How is sql used in oracle?

0 Answers  

---

---

What is posting?

0 Answers  

---

What is difference between sql and excel?

0 Answers  

---

How do you optimize a stored procedure query?

0 Answers  

---

Use The Implicit cursor to Query The Department table information Where Deptno is 30.check,if no record was found then print "Record Was Not Found".Else Print Deptname And Ename.Dept table Have Dname Varchar2(20),Deptno Number,EnameVarchar2(20).Please Answer In 2 mins,with in Maximum 15 lines.

5 Answers   Wipro,

---

Is sql easier than java?

0 Answers  

---

How do you determine the current isolation level? : Transact sql

0 Answers  

---

what is the cursor and use of cursor in pl/sql ?

4 Answers  

---