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
- 3920 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 do you mean by a database transaction & what all tcl statements are available in oracle?
How to convert a string to a date in oracle database?
how to get required data from oracle source is like this ram_05_seetha lax_05_viswa bamr05frummy run_01_away sw_sas_trim i want my target data like ram_05_seetha lax_05_viswa to get data using %_05_% but it will give ram_05_seetha lax_05_viswa bamr05frummy how can i get my target data?
What is recycle bin in Oracle?
What is meant by joins?
What are the differences between number and binary_float in oracle?
How many types of synonyms in Oracle?
What are the factors causing the reparsing of SQL statements in SGA?
how to use sequence and what use of sequence cache
Why does oracle 9i treat an empty string as null?
i can't insert column value greater than 4000 characters at one instance even i am using CLOB datatype . how to insert efficiently more than 4000 characters ? And please let me know how to impose inline and out-of line constraints on oracle column??? Thanks in Advance... Prakash
What should be the return type for a cursor variable.Can we use a scalar data type as return type?
Oracle General 
