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
- 3571 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
How to open a read-only file in the shell?
Determine the output of the following command: name=shubham && echo ‘my name is $name’.
How do I set bash as default shell mac?
Explain about gui scripting?
Rewrite the command to print the sentence and convert the variable to plural: echo “i like $variable”.
Is powershell a bash?
What are the various stages of a linux process it passes through?
How will you print the login names of all users on a system?
How are shells born?
Please give me example of " at command , contrab command " how to use
Why should we use shell scripts?
Is scripting and coding the same thing?
What are the different types of variables used in shell script?
Calculate a real number calculation directly from the terminal and not any shell script.
How will you find the 99th line of a file using only tail and head command?
