8i | 9i | 10g | 11g | 12c | 13c | 18c | 19c | Misc | PL/SQL | SQL | RAC | WebLogic | Linux

Home » Misc » Here

Comments for Analytic Functions


Soma said...

Thank you so much for this article
The lucid language with the excellent examples made the understanding of analytical queries so easy.........Thank u again

Mindy said...

Excellent!

Anon said...

This is fantastic, thank you.

vinod said...

Simly Superb..the tricky analytical functions explained very clearly..in easy manner.

Thank you so much.

Ankush said...

Cystal clear

Danny said...

Best explanation of oracle analytics on the web. Thank you!!!

Vissu said...

Cleared my confusions over these type of functions... Thanks Tim,...

lux said...

It's wonderful...simply superb...Thank u !!!

Niraj Choraria said...

Excellent!!.. very well drafted and real time good examples have been given. Thanks a ton

Paddy said...

It is an extremely well written article and helped me a lot to understand analytical functions. However, could you please elaborate more on the windowing clause (for example what is the difference between RANGE BETWEEN and ROWS BETWEEN, Using windowing clause without BETWEEN keyword).

Tim... said...

Hi Paddy.

Sorry for the delay in responding. I've added some sentences to the windowning_clause section to cover your points. :)

Cheers

Tim...

pelit said...

Thanks for those great instructive examples.

Anonymous said...

Hi,
I am not sure if this blog is still being monitored. However, I would like to thank you elucidating such an important concept with simplicity.
However, I was unable to understand the below sentence-
"As a result, duplicate rows are only included in the average when the salary value changes."

Would you mind explaining it compared to Row Between clause?

Tim... said...

Hi.

Sorry. That sentence was terrible, and completely the opposite of what is happening. I've reworded it and added an example to allow you to see what is happening. It is effectively allowing the window the extend beyond the current row, to other rows with the same reporting value. That could be confusing if it's not what you expect.

Cheers

Tim...

DO NOT ask technical questions here! They will be deleted!

These comments should relate to the contents of a specific article. Constructive criticism is good. Advertising and offensive comments are bad and will be deleted!

If you post personal information (name, email address etc.) you are agreeing to them being stored and displayed. Feel free to remain anonymous.