Interested to Buy Any Domain ? << Click Here >> for more details...
i want department wise maxmum salary and empolyee name
- 9 Answers
- 29356 Views
- I also Faced
- E-Mail Answers
Answer Posted / jaber badarneh
SELECT ENAME ,SAL ,DEPTNO
FROM EMP
WHERE SAL IN (SELECT MAX(SAL) FROM EMP GROUP BY DEPTNO)
| Is This Answer Correct ? | 19 Yes | 19 No |
Post New Answer View All Answers
How do I know if oracle is installed on windows?
What is an oracle user role?
How can I convert single byte kana characters into multi byte kana characters and vice-versa.
How do we get field details of a table?
I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance
What is the scope of a local variable?
How to execute a stored procedure in oracle?
How can we create the complete backup of data in the oracle.
What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.
What are the four Oracle system processes that must always be up and running for the database to be useable?
Explain the use of consistent option in exp command.
Differentiate between pre-select and pre-query?
Can we insert data in view oracle?
How to define an anonymous block?
What is a trace file and how is it created in oracle?
