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
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
Explain an index?
What is the purpose of save points in oracle database?
What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.
What are operators in oracle?
How to change user password in oracle?
How to loop through data rows in the implicit cursor?
What is connection pool in oracle?
How to name query output columns in oracle?
How oracle handles dead locks?
Explain user account with reference to oracle.
Explain the use of record option in exp command.
What is Undo Management Advisor in Oracle?
How to define default values for formal parameters?
What is difference between truncate and delete?
An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?