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
- 4875 Views
- I also Faced
- E-Mail Answers
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
can anyody please send me the dump for Oracle 10g certifications for DBA path?
How to write numeric literals in oracle?
What is the disadvantage of User defind function?
 How to use an oracle sequence generator in a mapping?
Why is oracle database so popular?
What is oracle in java?
A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.
Why do we need integrity constraints in a database?
How to pass parameters to procedures in oracle?
How to run queries on external tables?
What is system tablespace?
How to define a procedure inside another procedure?
What privilege is needed for a user to query tables in another schema?
Write a syntax for update query in oracle?
State the various uses of dbcc command?
