⟩ Tell me Dept wise average salary?
select deptno,trunc(avg(sal))as avg from emp group by deptno;
Question and Answer:
Home Database Management
- Share
Popular Answers:
* There is no answer to the above question yet.
More Questions for you:
If you have a five-gallon jug and a three-gallon jug. You must obtain exactly four gallons of water. How will you do it?
If you are faced with two doors. One door leads to your job offer (that's the one you want!), and the other leads to the exit. In front of each door is a guard. One guard always tells the truth. The other always lies. You can ask one question to decide which door is the correct one. What will you ask?
Tell me how many gallons of white house paint are sold in the U.S. every year?
What is size of market for disposable diapers in China?
How many square feet of pizza are eaten in United States each month?
Would you estimate the weight of the Chrysler building?
Why are the manhole covers round?
If you have 12 balls. All of them are identical except one, which is either heavier or lighter than the rest. The odd ball is either hollow while the rest are solid, or solid while the rest are hollow. You have a scale, and are permitted three weighing. Can you identify the odd ball, and determine whether it is hollow or solid?
Company has 10 machines that produce gold coins. One of the machines is producing coins that are a gram light. How do you tell which machine is making the defective coins with only one weighing?
Four members of U2 (Bono, the Edge, Larry and Adam) need to get across a narrow bridge to play a concert. Since it's dark, a flashlight is required to cross, but the band has only one flashlight, and only two people can cross the bridge at a time. (This is not to say, of course, that if one of the members of the band has crossed the bridge, he can't come back by himself with the flashlight.) Adam takes only a minute to get across, Larry takes two minutes, the Edge takes five minutes, and slowpoke Bono takes 10 minutes. A pair can only go as fast as the slowest member. They have 17 minutes to get across. How should they do it?
