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
- 4796 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 |
Define oracle database
Difference between primary key and unique key ?
77 Answers Accenture, B2B Software Technologies, Cognizant, HP Finsoft, IndiaNIC, Karomi Technology, Keane India Ltd, L&T, Onward eServices, R Systems, Shakti, Techtic Solutions,
what is insert all statement in sql
25. Display the client number and the value of the highest value order placed by that client.
a query to select maxmun 3 salaries of employee table
What is the difference between a vector and an Array? (Java)
you are sorting a table using "order by"(descending) clause of a column which contains a null value...whether that row containing null value will come first or last in the output??
How to enter a new row into a table interactively?
What is the effect of setting the value "ALL_ROWS" for OPTIMIZER_GOAL parameter of the ALTER SESSION command ?
8. Display the client name and order date for all orders using the natural join keywords.
What are transaction isolation levels supported by oracle?
What do you mean by a tablespace?
Oracle General 
