There are three departments A,B and C.Write a query to
display the names of all the persons( in departments other
than A) who are paid higher than the person receiving the
lowest salary in DEPT A
- 1 Answers
- 3579 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / ofss
select E.name from department D, emp E
where D.name = E.dname
and E.dname <> 'A'
and E.sal > (select min(E.sal) from department A, emp E
where A.name = E.dname
And E.dname = 'A')
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is the command to find out users on the system?
How do I set bash as default shell mac?
What are the advantages of shell script?
What shell is bin sh?
How do scripts work?
What does path stand for?
What is the first line in every perl script called?
What is @echo off?
What is the use of echo in shell script?
Set up a Sev 2 alert when the Primary WA service fails. A windows batch script needs to be created that will monitor the WA service on the Primary and when the service stops/fails a Sev 2 TT is generated for a particular team ?
What is a shell? · Types of shell · what is shell scripting?
What is the use of a shebang line?
What is shift command in shell script?
Is powershell a bash?
Explain about gui scripting?
