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
- 4893 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 |
Can you assign multiple query result rows to a variable?
What should be the return type for a cursor variable.Can we use a scalar data type as return type?
who is the father of oracle and send chodd rules
Display the records between two range?
What is catalog in Oracle?
What does COMMIT do ?
What is the difference between view and materialized view in Oracle?
difference between oracle8i and oracle9i
What is instant client oracle?
How to add a new column to an existing table in oracle?
what is the difference between table and veiw?
how to find count rows in table without count function?
Oracle General 
