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
- 4442 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 |
What is the first line of a shell script called?
How can you get the value of pi till a 100 decimal places?
What is the default shell of solaris?
madhar chod unix ke 10 commands dhang se likh nahi sakta hai
How do I open the shell prompt?
How do I stop script errors?
How would you compare the strings in a shell script?
How to declare functions in unix shell script?
How can the contents of a file inside jar be read without extracting in a shell script?
How do you create a shortcut in linux?
I want to create a directory such that anyone in the group can create a file and access any person's file in it but none should be able to delete a file other than the one created by himself.
Write down the syntax for all the loops in shell scripting.
ASP 
