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
- 3563 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 |
Explore about environment variables?
How do I save a powershell script?
What are the different methods available to run a shell script?
What does $1 mean in bash?
Is it possible to substitute "ls" command in the place of "echo" command?
give me some website where i can get unix and testing meterials
c program to display the information of given file similar to givan by the unix or linux command ls -l
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 the syntax of "expr" command?
What are scripts in psychology?
Print a given number, in reverse order using a shell script such that the input is provided using command line argument only.
What is egrep?
ASP 
