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
- 7414 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / parag
1) SELECT DISTINCT DEPT FROM TABLE
WHERE SAL >=
(SELECT MAX(SAL) FROM TABLE
WHERE MONTH = 'JAN');
2) SELECT DISTINCT DEPT, SAL FROM TABLE
WHERE SAL >=
(SELECT MAX(SAL) FROM TABLE);
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
How to view the data files in the current database?
hi friends i completed b.com 2004.i have 3y accounting exp. in manufacturing company.now i have completed oracle finance.pls suggest me how will get job in oracle.can i get job in oracle.
HI, Please let me know the syllabus for Oracle OCA and OCP Certification
List out the components of logical database structure of oracle database.
how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?
What is dual table oracle?
What are the types of partitions in oracle?
What are the uses of linked server and explain it in detail?
How can Oracle users be audited?
Why do we need integrity constraints in a database?
what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?
what are the default admin accounts in Oracle 10g ?
What are the uses of Database Trigger ?
How to return top 5 rows in oracle?
What is the relationship among database, tablespace and data file?
