Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 6545 Views
- Oracle, I also Faced
- E-Mail Answers
Answer Posted / humera
Answer Q # 37
select e.ename,d.dname from emp e left outer join dept d on
e.deptid = d.deptid
| Is This Answer Correct ? | 1 Yes | 4 No |
Post New Answer View All Answers
Explain three modes in which files can be accessed from python program
code for connection from windows forms to sql server
Hello...has anyone interviewed with Information Management Services(IMS)located in Silver Spring MD??If yes,what can you share about the programming test and the analytical test?
which worker is involved in all the phases of SDLC?
what is web configuration file
What is the use of Differ interface check box in Ship confirm?
What binary value will be internally stored for NULL for the type S9(1) COMP 3 in mainframe
If u need any fake experience certificate in software side, contact me at: vikramyadhav@gmail.com
smal talk is pure object oriented or not?
5. Which of the following can you do with DB2 Express- C? Query databases with SQL Query databases with XML using XQuery and XPath Use SQL in Xquery and Xquery in SQL All of the above
How to use string functions in QTP?give some examples
How many forms can you create in a Visual Basic 6 Standard EXE project? Is there any limit on that?
What's the difference b/w Table & Templete in Smartform?
Hello Experts, What is the difference between move and move corresponding exactly? please post me asap
Difference between HTML and DHTML?
