Interested to Buy Any Domain ? << Click Here >> for more details...
consider a table which contain 4 columns,ename,eno,sal and
deptno, from this table i want to know ename who having
maximum salary in deptno 10 and 20.
- 24 Answers
- 31233 Views
- Mind Tree, I also Faced
- E-Mail Answers
Answer Posted / vishnu prasad.ma
SELECT A.EMP_NAME, SUM(B.MAX_SALARY) AS MAX_SAL, B.EMP_DEPT_NO FROM EMP_DETAILS A,
(SELECT MAX(EMP_SAL) AS MAX_SALARY, EMP_DEPT_NO FROM EMP_DETAILS WHERE EMP_DEPT_NO IN (10,20)
GROUP BY EMP_DEPT_NO) B
WHERE
A.EMP_SAL = B.MAX_SALARY
AND A.EMP_DEPT_NO = B.EMP_DEPT_NO
GROUP BY A.EMP_NAME, B.EMP_DEPT_NO
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How do I truncate a word?
What is db journal file?
how to rename an existing column in a table? : Sql dba
What is the difference between row level and statement level trigger?
What are all the common sql functions?
discuss about myisam key cache. : Sql dba
why does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba
what is try_catch block in procedure
What is sql and explain its components?
What is difference sql and mysql?
What is pl/sql language case sensitive?
how to present a past time in hours, minutes and seconds? : Sql dba
Why join is faster than subquery?
What is a recursive stored procedure?
What is the function that is used to transfer a pl/sql table log to a database table?
