Interested to Buy Any Domain ? << Click Here >> for more details...
i want department wise maxmum salary and empolyee name
- 9 Answers
- 30124 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
Explain the use of indexes option in imp command.
Explain the difference between sql and oracle?
In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??
How do I uninstall oracle client from windows?
What do you understand by database schema and what does it hold?
How to drop an index in oracle?
What is private procedure oracle?
What are the logical operations?
Explain user account with reference to oracle.
What happens if you lost a data file?
How to return top 5 rows in oracle?
Explain the blob datatype?
what is the scenario where you take the database to NoArchivelog mode?
1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.
Design database draw er diagram for a certain scenario ?
