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
- 4432 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
Why is used in shell scripting?
How do I open the shell prompt?
How do I run a .sh file?
how to get part of string variable with echo command only?
What language is shell scripting?
Suppose you execute a command using exec, what will be the status of your current process in the shell?
Explain about sourcing commands?
How do I run a powershell script?
What is c in shell script?
What lives in a shell?
How will you copy a file from one machine to other?
Can you write a script to portray how set –x works?
Give some situations where typing error can destroy a program?
How would you compare the strings in a shell script?
What is shell company all about?
