Query Problem

Please explain me what is analytical function?
I couldnt get ur code.

Quote:

---

Originally posted by subodh_04
Please explain me what is analytical function?

---

They're in the SQL Reference guide. They are basically windowing functions that operate on a result set to perform an aggregate-type function within the set.

for example ...

Code:

---

select
  emp,
  dept,
  salary,
  job,
  avg(salary) over (partition by dept)
      avg_dept_salary,
  avg(salary) over (partition by job)
      avg_job_salary,
  avg(salary) over ()
      avg_company_salary
from
  emp

---

... would allow a comparison of every salary with the average employee salary for that department, the average for the company, and the average for the job.

Very powerful stuff.

WOW
Guess I should read the damn documation.

slimdave

do you know how to ensure the inline views is always resolved first :-?

Quote:

---

Originally posted by pando
slimdave

do you know how to ensure the inline views is always resolved first :-?

---

If the inline view contains an analytical function then i believe it would always be resolved first. I don't think that predicates would get pushed down into the view because that could fundamentally change the result.