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
4876 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 create a testing table in oracle?

991

Hi Can any one tell me what are the API's used in requisition import.

1923

How to rename a column in an existing table?

1035

How to enter a new row into a table interactively?

1014

is there a tool to trace queries, like profiler for sql server?

1141

How view is different from a table?

1036

What are a query and state the different types of queries and their uses?

1017

How to load a large xml file?

1056

How do I manually uninstall oracle client?

1089

How can we find out the current date and time in oracle?

1090

What is a dead lock in oracle?

1123

Is there any function in oracle similar like group_concat of mysql?

1053

How to specify default values in insert statement using oracle?

1106

Why packages are used in oracle?

1067

What is difference between truncate and delete?

1040