I have query like this. select dept_id, max_mark from stude_dept where min

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

Question Posted / pradeeshkumar

2 Answers
3673 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

I have query like this. select dept_id, max_mark from stude_dept where min_mark= (select min(min..

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

I have query like this. select dept_id, max_mark from stude_dept where min_mark= (select min(min..

Answer / sudhakar

hi
it gives mini_mark record of max_mark,dept_id

Is This Answer Correct ?

0 Yes

0 No

Post New Answer