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 |
Differentiate between translate and replace?
Why do you create or replace procedures rather that drop and recreate.
What does `(+)` do in a where clause?
Where do we use decode and case statements?
when loggined as SYSTEM,how to display all the users of database using sql query?
how many columns can a plsql table have
Does oracle database need java?
Hi how Can I Add A Foreign key that references a table that has composit primary key ? example i had costumer table that has C_Id and SSN Both as PK and another table has C_Id that must refernece C_Id in Customers i done the usual way and got oracle error message about uniqeness any ideas plz
Can you drop an index associated with a unique or primary key constraint?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
How to omit columns with default values in insert statement in oracle?
What is oracle open database communication (odbc)?