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
- 4881 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 the parameter mode that can be passed to a procedure?
State the various uses of dbcc command?
What is Network Database link ?
What is a database table in oracle?
What are the values that can be specified for OPTIMIZER MODE Parameter ?
How to change system global area (sga) in oracle?
Indexes in oracle ?
3 Answers Keane India Ltd, L&T,
Define Transaction ?
How to find no of saturdays in a month using single sql ?
What is a oracle database?
What are the various types of snapshots ?
What are the uses of synonyms?
Oracle General 
