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
- 4436 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 use of script interpreter in shell scripting?
Given a file find the count of lines containing the word "abc".
how do you write sql queries using shell script for eg:- we have databae table like EMPNO,ENAME,SAL,DEPTNO columns in EMP table how you display EMPNO,SAL FIELDS from emp in SHELL SCRIPT please explain with an example
How can we find the process name from its process id?
Create a bash shell script that reads a line from the user consisting of 5 words and then prints them out in reverse order. Name this script "reverse.sh"
What is the purpose of scripting?
Why are shell scripts used?
Please give me example of " at command , contrab command " how to use
How do I edit a .sh file?
How many fields are present in a crontab file and what does each field specify?
How do you rename the files(*.sh) with file names containing space in it?for example "interview question.sh" needs to rename to "interview-question.sh". Appreciate your inputs.Thanks.
how did u debugging in unix/ linux platform ??( project Related)
ASP 
