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 / venkateswara reddy
1)select dept from E where sal=(select max(sal) from E where
month='JAN')
2)select dept from E where sal=(select max(sal) from E)
Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What are the most common interview questions on ETL Testing for experience?
material view and view disadvantages?
What is bulk copy or bcp in oracle?
What is the difference between substr & instr functions?
what are the default admin accounts in Oracle 10g ?
what is the use of triggers in Java program? I mean where do we use triggers in Java programming?
What is an oracle data file?
What is the sql query to concatenate column values from multiple rows in oracle?
Difference between inner join vs where ?
hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards
Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.
How to load excel data sheet to oracle database
while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511
How to return top 5 rows in oracle?
What is analyze command used for?