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
- 4851 Views
- I also Faced
- E-Mail Answers
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 |
What is Rollback Segment ?
what is primary key?
how to insert the image in table
What is query image?
what is cartesian product?
Suppose U install the oracle DB either enterprise edition or express edition in ur personal PC, Is there the Database has been created after ur installation if not then where the oracle's all objects with data be stored?
State any two functions of oracle?
How to open a cursor variable?
can you call insert/update/delete in select statements. If yes how? If no what is the other way?
How to start your 10g xe server from command line?
What is oracle in java?
How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?
Oracle General 
