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
- 4964 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 are the advantages of oracle?
Does a Before form trigger fire when the parameter form is suppressed ?
What is a data segment ?
What is Rollback Segment ?
Difference between pre-select and pre-query
why you need store procedure ? where do we use it in a Java project? can you get the code for as store procedure using in Java?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
1.how to extract the second highest salary from emp table having sal as a column which contains the salary of all employee of an organisation.
i deleted 4 records form the table.after i have applied commit .now i want to get back those records.how?
What is parameterized cursor in oracle?
How do I uninstall oracle client from windows?
How to generate query output in html format?
Oracle General 
