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
- 4377 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 |
How to pass an argument to a script?
Hi Friends, I am currently Undergoing Course On Testing.I am Planning To Keep Fake Resume.Can any One tell me the ways to Prepare i.e, Real Time experience For Manual Testing. With Regards, Vikram
What will happen to my current process when I execute a command using exec?
What language is shell scripting?
Is it possible to substitute "ls" command in the place of "echo" command?
Explain about "s" permission bit in a file?
What is bourne shell scripting?
Explain about sourcing commands?
Hi, all Scripting professional. Q. I have written script1.sh and calling script2.sh in script1.sh file using bash shell as interpreter and my log in shell also bash shell.My code like Script1 #!/bin/bash echo "My script2 call" . script2.sh Here script2.sh file run successfully but when I have changed my interpreter bash to ksh like #!/bin/ksh Error are comming script2.sh command not found. Guid me how to call other script in our main script.
What is the purpose of scripting?
How to take input values from the user?
What is bash coding?
ASP 
