Table E:
Name dept month sal
1 A JAN 800
2 B APR 1000
3 A JAN 300
4 A JAN 600
5 C JUN 400
1) SELECT HIGHEST SAL PAID DEPT IN JAN MONTH?
2) WRITE QUERY GET MAX SAL DEPT NO?
Answer Posted / shilpa
1) select dept , max(sal) from E where month=JAN';
2) select dept , max(sal) from E ;
Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
What are the ansi data types supported in oracle?
How to define an oracle cursor variable?
does the query needs a hint to access a materialized view?
Can we create trigger on materialized view in oracle?
Why do we use coalesce function in oracle?
How to define a data field as not null?
How to install oracle odbc drivers?
What is recovery manager in Oracle?
How to define an anonymous block?
How to list all indexes in your schema?
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.
Can we protect our pl/sql source code?
How do I use unicode codesets with the weblogic jdriver for oracle driver?
What are group functions in oracle?
material view and view disadvantages?