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
- 7241 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / mayur
select max(sal) from e where sal in (select month form e
where month = 'JAN';
| Is This Answer Correct ? | 0 Yes | 5 No |
Post New Answer View All Answers
Explain the use of grant option in imp command.
What is an Oracle Instance?
HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE
How to convert dates to characters in oracle?
How to convert a date to char in oracle? Give one example.
Is it possible to insert comments into sql statements return in the data model editor ?
What is the quickest way to export a table to a flat file?
Briefly explain what is literal? Give an example where it can be used?
State the difference between a primary key and foreign key?
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??
What is the difference between translate and replace?
Can we store pictures in the database and if so, how it can be done?
what is the scripts in data base?
What are the parameters that we can pass through a stored procedure?
How to convert characters to times in oracle?
