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
4770 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 are the advantages of running a database in archive log mode?

2144

What is a nvl function?

958

Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

1829

how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?

2291

Explain the use of grant option in exp command.

1006

What is an oracle data file?

1039

Where is the export dump file located?

1082

How to use fetch statement in a loop?

973

How can I create database in oracle?

961

What are the most common interview questions on ETL Testing for experience?

1079

What is SQL access advisor in Oracle?

1137

how do u setup a replication site?

1925

How to start your 10g xe server?

970

What is ASM (Automatic Storage Management) in Oracle?

1124

How to shutdown your 10g xe server from command line?

1015