hi it gives mini_mark record of max_mark,dept

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 / sudhakar

2 Answers
4813 Views
I also Faced
E-Mail Answers

Answer Posted / sudhakar

hi
it gives mini_mark record of max_mark,dept_id

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is a user account in oracle?

1082

What is an index associated with a constraint?

998

How do we get field detail of a table?

1041

Explain an index?

1107

How to define default values for formal parameters?

1007

What is a select query statement in oracle?

923

What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.

943

What are the uses of synonyms?

1106

How to write date and time literals in oracle?

969

State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.

1002

How to use "startup" command to start default instance?

990

What to do if dba lost the system password?

1123

How to create tables for odbc connection testing?

1050

How to pass a cursor variable to a procedure?

1067

What are the restrictions on external table columns?

1013