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
- 4428 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
Write a command sequence to find the count of each word?
What is @echo off?
What is k shell?
How does path variable work?
Explain about echo command?
How does ls command work?
How to replace following lines, catch (DAOException e) { objLogger.error(this.getClass () + "addUpdateIssues() " + e); throw new BOException(5122); } catch (BOException e) { objLogger.error(this.getClass () + "addUpdateIssues() " + e); throw e; } catch (Exception e) { objLogger.error(this.getClass () + "addUpdateIssues() " + e); throw new BOException(5122); } Needs to be changed in to, catch (DAOException e) { AppException.handleException (null, null, e, null, null, null, "BOException", this.getClass() + "addUpdateIssues() ", null, null, null, null, null, null, null, null, 5122); } catch (BOException e) { AppException.handleException (null, null, null, e, null, null, "BOException", this.getClass() + "addUpdateIssues() ", null, null, null, null, null, null, null, null, 0); } catch (Exception e) { AppException.handleException (null, null, null, null, null, e, "BOException", this.getClass() + "addUpdateIssues() ", null, null, null, null, null, null, null, null, 5122); }
How do you create a shortcut in linux?
I want to connect to a remote server and execute some commands, how can I achieve this?
Write a script to print the first 10 elements of fibonacci series.
How to open a read-only file in the shell?
How do I run a powershell script?
How to check if the previous command was run successfully?
What is a batch file used for?
What makes c shell a more preferable option than the bourne shell?
