Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 4339 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 |
What is .sh file in mac?
What is the first line in a shell script?
What are types of shells?
How many prompts are available in a UNIX system?
Given a file find the count of lines containing the word "abc".
When should shell programming/scripting not be used?
What are the various stages of a linux process it passes through?
Explore about environment variables?
What is shell terminal?
What is a batch file used for?
What lives in a shell?
How to customise the other shell?
ASP 
