Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 4888 Views
- I also Faced
- E-Mail Answers
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 |
What is a recycle bin in oracle?
what is difference between sql plus and sql*plus? (not sql and sql plus).
What are the different editions of oracle?
Can you have more than one content canvas view attached with a window ?
Youre getting high busy buffer waits - how can you find whats causing it?
Is it possible to split the print reviewer into more than one region ?
i have procedure p1.and also i declare the same procedure in a package. whice one is efficient package procedure or procedure?
Why we use bulk collect in oracle?
which is the best training centre for learning oracle?
Is java required for oracle client?
What is the difference between sharding and replication?
What are the varoius components of physical database structure of oracle database?
Oracle General 
