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
- 4791 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
Please explain compound trigger in oracle?
What is the use of aggregate functions in oracle?
How to change program global area (pga) in oracle?
How to export data to a csv file?
How to use fetch statement in a loop?
What is snapshot is too old? Give and example for better understand.
What do database buffers contain?
What are the restrictions on external table columns?
What is an oracle cursor variable?
defination of bitmap index
How to rename an existing table?
What are the differences between number and binary_float in oracle?
Can you drop an index associated with a unique or primary key constraint?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
What is the relation of a user account and a schema?
