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
4845 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 exactly do quotation marks around the table name do?

946

What is the difference between sharding and replication?

1015

How do I call oracle stored procedures that take no parameters?

1084

Explain the use of parfile option in exp command.

1046

How can we force the database to use the user specified rollback segment?

1116

How to delete multiple rows from a table in oracle?

1049

What is a data lock in oracle?

1077

How to turn on or off recycle bin for the session?

1082

Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com

1847

How to get a create statement for an existing table?

946

ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process

2240

What is query image?

964

What is a sub query? What are its various types?

1147

What do you mean by a database transaction & what all tcl statements are available in oracle?

970

What is a package ? What are the advantages of package ?

1071