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
- 4963 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 group functions be used in the order by clause in oracle?
How to delete multiple rows from a table in oracle?
i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)
What are the uses of a database trigger?
Explain overloading. Can functions be overloaded?
Why is oracle used?
How to insert multiple rows with one insert statement in oracle?
State and explain the different types of data models?
How to create a new table in your schema?
State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.
What is hot backup and logical backup?
I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?
Please explain compound trigger in oracle?
What is literal?
How do I use unicode codesets with the weblogic jdriver for oracle driver?
