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
- 4499 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
When should shell programming/scripting not be used?
Suppose you execute a command using exec, what will be the status of your current process in the shell?
Using set -A write a script to print the output of the ls command in 5 columns with two spaces between each column. Pretend that ls does not have multicolumn output.
Where is bash history?
c program to implement unix/linux command to block the signal ctrl-c and ctrl-\ signal during the execution ls -l|wc -l
c program to display the information of given file similar to givan by the unix or linux command ls -l
What is the use of a shebang line?
How many fields are present in a crontab file and what does each field specify?
What is the default shell of solaris?
How do I run a shell script on a mac?
What is bourne shell scripting?
Can we run shell script in windows?
What does $0 mean in shell script?
What is bash shell command?
What does $1 mean in bash?
