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
4965 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

How to build data dictionary view an new database?

1051

Can we create database in oracle using command line ?

1131

What is the data pump import utility?

1074

What are the data types in oracle?

1095

How index is implemented in oracle database?

1043

Can you create a synonym without having a table?

1091

How to use regular expression in pattern match conditions in oracle?

1074

How to insert a record into a table?

1120

What is the quickest way to fetch the data from a table?

1100

What is MTTR advisor in Oracle?

1137

Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.

1395

What is recovery manager(rman) backup in Oracle?

1230

How to delete an existing row from a table in oracle?

1129

What is the maximum limit on the number of columns in a table?

1151

What do database buffers contain?

1082