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
- 4765 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 |
How to join two tables in a single query using oracle?
What is a proxy class?
How would you best determine why your MVIEW couldnt FAST REFRESH?
What are a query and state the different types of queries and their uses?
3. Adapt your query in (2) above so that only post codes with more than twenty orders are displayed.
In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.
when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.
How to delete a column in an existing table in oracle?
What is oracle update statement with inner join ?
How can we view last record added to a table?
What is bulk copy or bcp in oracle?
definition of cluster and non-clustered index?
Oracle General 
