i want department wise maxmum salary and empolyee name
Answer Posted / shiva
select deptno,ename,max(sal)
from emp
group by deptno,ename;
| Is This Answer Correct ? | 0 Yes | 7 No |
Post New Answer View All Answers
What is the scope of a local variable?
How to retrieve the count of updated rows?
How to write a query with an inner join 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.
Explain user account with reference to oracle.
How to invoke the data pump import utility?
How to create a new table in your schema?
What is logical backup in oracle?
What is the usage of merge statement?
What are the common oracle dba tasks?
How do I connect to oracle?
How to convert raw data type into text in oracle? Explain
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?
How to write date and time interval literals in oracle?
How to shutdown your 10g xe server?