There are 2 tables: EMP : EmpId, Ename, Sal, DeptId DEPT : DeptId, Dname Write a query to find out emp names and their department names. if any emp has null in Deptid the it shows ?No Department?. Write a query to find out those department names which has no employee. Write a query to find out those employees whose salary is greater than their department?s average salary.

1 Answers   Oracle,

---

why rownum=1 works properly but not rownum=>2,=>3 etc.

0 Answers   Oracle,

---

what is the difference between java , sap ,.net , orecle apps ?

1 Answers  

---

How do you initialize a static member of a class with return value of some function?

0 Answers   Yahoo,

---

What do you mean by an array ? explain with an example

7 Answers  

---

when a query is made on Logical file in DB2/400, will the records satisfying select/omit criterion be fetched from all members of physical file or only the member with same name as physical file?

0 Answers  

---

what is the purpose of postback?

2 Answers   Nth Solution,

---

Write 5 differences between Memory Reference Instruction and Register Reference Instruction.

1 Answers   TCS, TJM,

---

in cobol,wat is the difference in using 'set index in occurs clause' ....and 'occurs depending-on clause'

0 Answers   Infosys,

---

There are 3 jars containing two types of round marbles. One jar contains only red marbles, one jar contains only blue marbles and the third jar contains a mix of both red and blue marbles. Although the jars are labeled “red”, “blue” and “mixed” – all the jars are mislabeled. How many marbles would you have to pull out, and out of which jars, to find out how to fix the labels correctly?

1 Answers   Syntel,

---

What is meant by QUEUE?

4 Answers   Mascot,

---

What is a dialog based program

1 Answers  

---