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
- 5758 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
Differentiate between translate and replace?
What is the quickest way to export a table to a flat file?
what are the advantages of running a database in archive log mode?
ABOUT IDENTITY?
How many types of database triggers exist?
How to update a table row with a record?
What is Data Dictionary Cache in Oracle?
How to view existing locks on the database?
What is rich query?
How to display employee records who gets more salary than the average salary in the department?
hello friends Im doing my final year engineering in B.Tech.. one of uncle said he can provide job in his company if im good in database management. but i have only basic knowledge about database, so like to join database management course in good intuition. so friends kindly help me to get good intuition because its my future.
Explain an index segment?
What is a directory object?
What is dynamic proxy?
When do we use group by clause in a sql query?
