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
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / sudhakar
hi
it gives mini_mark record of max_mark,dept_id
Is This Answer Correct ? | 0 Yes | 0 No |
How do you tell what your machine name is and what is its IP address?
What is a package ? What are the advantages of package ?
What is the use of Control File ?
What is open database communication (odbc) in oracle?
What is the difference between pre-select and pre-query?
How to rollback the current transaction in oracle?
How do I escape a reserved word in oracle?
what is meant by magic query
What is object data modeling?
What is a deadlock ? Explain .
What are steps required to ENTER DATA INTO DWH?
15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.