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
- 3581 Views
- Wipro, I also Faced
- E-Mail Answers
Answer / 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 |
How to get the first line from a file using just the terminal?
How to make userdefined variables to available for all other shells?
Is shell script a programming language?
What is "test"? How it is used in shell scripting?
What is sudo command?
What is the first line in every perl script called?
When should shell programming/scripting not be used?
How will you find the 99th line of a file using only tail and head command?
I have 2 files and I want to print the records which are common to both.
How do I run a shell script in powershell?
What is the command to find out users on the system?
What language is bash?
ASP 
