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
- 4500 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 |
Is shell and terminal the same?
How to check if a directory exists?
What is in a script?
What are script files?
What command needs to be used to take the backup?
What does the sh command do?
Explain about the slow execution speed of shells?
Hi, i want to zip the files that generates automatically every few minutes (files generated are in .arc extension)....any body write a script for this... thanks in advance
what is this line in the shell script do ?#!/bin/ksh
Explain about stdin, stdout and stderr?
whta is the use of "exec" command?
What is the difference between a shell variable that is exported and the one that is not exported?
ASP 
