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
- 4398 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
Please give me example of " at command , contrab command " how to use
How to get the last line from a file using just the terminal?
What happens on a system call?
Write the syntax for "if" conditionals in linux?
What is shell prompt?
Explain how you Automate your application using Shell scripting.
What is the command to find out today's date?
Hello all, This is my assignment on shell scripting, can anyone help me regarding this ? Create a shell script which connects to the database In second shell script include the first script for the DB connection Create a table (PRADEEP_DATA) with 2 columns (name, value) In Third shell script include the first script for the DB connection And insert/delete the values from the Table, by accepting input from the user This functionality should be a menu driven Program: 1) Insert to the database a. Name b. value 2)Delete from the database a.Name b.value Exception handling needs to be taken care.
What is the purpose of scripting?
What is a shell in operating system?
How can you get the value of pi till a 100 decimal places?
Write a command sequence to find the count of each word?
What are "c" and "b" permission fields of a file?
How will you copy a file from one machine to other?
How do I run a bin bash script?
