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
- 4344 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
Write down the syntax for all the loops in shell scripting.
What is sh in shell script?
What are the different communication commands available in the shell?
Suppose you execute a command using exec, what will be the status of your current process in the shell?
How do I open the shell in cmd?
What is bash used for?
How do you find out What is your shell?
What's the difference between scripting and coding?
How would you compare the strings in a shell script?
What language is used in terminal?
Why do we write bin bash in shell scripts?
I want to monitor a continuously updating log file, what command can be used to most efficiently achieve this?
Set up a Sev 2 alert when the Primary WA service fails. A windows batch script needs to be created that will monitor the WA service on the Primary and when the service stops/fails a Sev 2 TT is generated for a particular team ?
What is the use of "$#" in shell scripting?
