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
Answer Posted / amrita basu
here the table name is stud_dept. now the query within
bracket fetches the minimum of minimum marks i.e min_mark
from stud_dept. now the total query gives the result such
as to fetch the dept_id and max_mark of the corresponding
min_mark. if u have any kind of prob regarding this ans.
plz send me mail amritabasu.mca09@gmail.com
Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What is the difference between PFILE and SPFILE in Oracle?
How to check the server version in oracle?
Explain mutating triggers.
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
How to invoke the original export import utilities?
Select all the employees who were hired in last 2 years and who works in dept where max managers are working.
What is a select query statement in oracle?
Can we store pictures in the database and if so, how it can be done?
How to synchronize 2 schema's objects?
Explain what are the advantages of views?
hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards
HI, Please let me know the syllabus for Oracle OCA and OCP Certification
How to view the data files in the current database?
how to convert .db (extention) database file into .dmp (extention ) for oracle database ?
why dont we assign not null constraint as table level constraint.