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
- 3575 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 |
When you login to a c shell, which script would be run first?
What does echo mean in scripting?
What is shell terminal?
How to write an Auto scripting for deleting old files using shell script and made a cron job to run on daily basis
Rewrite the command to print the sentence and convert the variable to plural: echo “i like $variable”.
Differentiate between ‘ and ” quotes.
how will you find the total disk space used by a specific user?
Is shell a scripting language?
how to find weblogic version through linux cammand
How do you print the output the same string which is typed in command line. how do you write the shell script or command for this. if i entered "Hello" in command line, it should print 'Hello', if i say "Hello Welcome", i should get the "Hello Welcome" as output.?
How to write a function?
how do you write sql queries using shell script for eg:- we have databae table like EMPNO,ENAME,SAL,DEPTNO columns in EMP table how you display EMPNO,SAL FIELDS from emp in SHELL SCRIPT please explain with an example
ASP 
