I have query like this.
select dept_id, max_mark from stude_dept where min_mark=
(select min(mini_mark) from stud_dept);
How can i optimize this query.
Can anyone help me with it
- 2 Answers
- 3922 Views
- I also Faced
- E-Mail Answers
Answer Posted / amrita basu
here the table name is stud_dept. now the query within
bracket fetches the minimum of minimum marks i.e min_mark
from stud_dept. now the total query gives the result such
as to fetch the dept_id and max_mark of the corresponding
min_mark. if u have any kind of prob regarding this ans.
plz send me mail amritabasu.mca09@gmail.com
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What are the different types of failures that occur in Oracle database?
Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..
What is rich query?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
Can we write insert statement in function in oracle?
What is the difference between online and offline backups?
how to join query for one source type is oracle another source type is sql server ?
How to concatenate two text values in oracle?
How to use "while" statements in oracle?
How will you identify oracle database software release?
What happens to the current transaction if a ddl statement is executed?
What is recovery manager(rman) backup in Oracle?
Differentiate between function and procedure in oracle.
Write a trigger example in oracle?
Please explain drop constraint oracle?
