Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 6 Answers
- 7252 Views
- IBM, I also Faced
- E-Mail Answers
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
Which is better Oracle or MS SQL? Why?
What will be the syntax to find current date and time in format "yyyy-mm-dd"?
How to put more than 1000 values into an oracle in clause?
How many types of synonyms in Oracle?
Is oracle an open source?
Explain overloading. Can functions be overloaded?
What is the difference between $oracle_base and $oracle_home?
What are a collation and state the different types of collation sensitivity?
what are steps for interface? where is exchange rate defined in which table?
How to sort the query output in oracle?
normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi
What are the set operators union, union all, minus & intersect meant to do?
what is Single Byte Overhead...?
How to create a server parameter file?
List out the components of logical database structure of oracle database.
