Interested to Buy Any Domain ? << Click Here >> for more details...
HOW TO DISPLAY MAXIMUM SALARIES FROM EMP DEPARTMENT VISE ALONG
WITH DEPARTMENT NAMES? E.g EMP,DEPT
- 5 Answers
- 10484 Views
- College School Exams Tests, DELL, I also Faced
- E-Mail Answers
Answer Posted / naveen
SELECT D.DEPTNO,D.DNAME,MAX(SAL) FROM EMP E,DEPT D WHERE
D.DEPTNO=E.DEPTNO GROUP BY D.DEPTNO,D.DNAME;
| Is This Answer Correct ? | 17 Yes | 1 No |
Post New Answer View All Answers
What is a snapshot log?
What is Virtual Private Database in Oracle?
types of indexes and the rationale behind choosing a particular index for a situation.
How to estimate disk space needed for an export job?
Explain what does a control file contain?
How to check the oracle tns settings?
Describe an oracle table?
Explain constraining triggers.
src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));
Explain oracle’s system global area (sga).
How to list all user accounts in oracle?
HI Friends Myself Manoj,i am from bengaluru.i have 1 yr of exp in PLSQL but not upto the mark..now attending interviews but m not able to clear even 1 round..i have attended 3 interviews till today.purpose of writing this query is,i want to know the intreview topics that interviewer going to ask frequently,mainly SCENARIO based questions.IF anybody have any PLSQL projects please give it to me,it will helps me alot.Thanks for your patience.
How to call a stored function in oracle?
Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?
What is control file used for?
