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
- 3569 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 |
write a non recursive shell script that accepts any number of arguments and prints them in the reverse order
What is meant by $1 in shell script?
determine the output of the following command: echo ${new:-variable}
Write a shell script to get current date, time, user name and current working directory.
What is bash used for?
What is .sh file in mac?
What is an inode block?
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
I want to read all input to the command from file1 direct all output to file2 and error to file 3, how can I achieve this?
How to enable the shell to know what program should be run to interpret the script?
What are scripts in psychology?
Is shell a scripting language?
ASP 
