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
- 4766 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
What are the differences between char and varchar2 in oracle?
How to convert csv to table in oracle?
List the types of joins used in writing subqueries?
What is MTTR advisor in Oracle?
What is ordinary table in oracle?
Explain the importance of .pll extension in oracle?
Explain mutating triggers.
What are group functions in oracle?
How to change program global area (pga) in oracle?
Explain integrity constraints?
We are using Oracle apps with XML publisher.In that,we are facing some problems while giving a Footer in RTF Template.While giving a footer in RTF Template it is Visible in all the pages,but after the PDF is getiing generated,the Footer are Visible on alternate pages only (like on first page ,third page) and so on. Please provide the Solution for getting the Footer on all the pages.
How to create a stored procedure in oracle?
Why is oracle database so popular?
What is redo log?
List the various oracle database objects?
