Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 2 Answers
- 4850 Views
- I also Faced
- E-Mail Answers
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
How to find out what oracle odbc drivers are installed?
Does facebook use oracle?
How to use "if" statements on multiple conditions?
How to open a cursor variable?
What are the different types of record groups in oracle? Explain each of them
Explain the use of compress option in exp command.
What is oracle analytical function?
Why do we use bulk collect in oracle?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
How to connect to the server with user account: sys?
Is insert autocommit in oracle?
How to use "while" statements in oracle?
How many types of cluster table in Oracle?
Explain the different normalization forms?
What is meant by joins? List out the types of joins.
