Home » SQL & PL/SQL » SQL & PL/SQL » analytical sql statements
analytical sql statements [message #240587] Fri, 25 May 2007 04:47 Go to next message
orafacjublu
Messages: 95
Registered: May 2006
Location: KOLKATA
Member
Can any one tell me a good book to learn how to write analytical sql statements. For example why we use over partion with a select statement.
Re: analytical sql statements [message #240592 is a reply to message #240587] Fri, 25 May 2007 05:00 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
The best source of information I found was the documents.

There are a lot of examples on this site that show things that you can do with them, and AskTom has a lot of information too.

But as I said - read the Documents. They explain what the various clauses do, and why you need them.
Re: analytical sql statements [message #241069 is a reply to message #240592] Mon, 28 May 2007 04:56 Go to previous messageGo to next message
orafacjublu
Messages: 95
Registered: May 2006
Location: KOLKATA
Member
can anyone explain me what is window ,sliding window and windowing clause in analytics with an example.
Re: analytical sql statements [message #241073 is a reply to message #241069] Mon, 28 May 2007 04:59 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Did you bother to read the link JRowbottom gave you?
ctrl-f in that page for window..
Re: analytical sql statements [message #241119 is a reply to message #241073] Mon, 28 May 2007 07:02 Go to previous messageGo to next message
orafacjublu
Messages: 95
Registered: May 2006
Location: KOLKATA
Member
Frank I read the documents but my concept regarding window,sliding window and windowing clause was not clear that is why I was asking for help. Please explain me or give me the name of a book which will explain these terms with simple examples.
thanks
Re: analytical sql statements [message #241124 is a reply to message #241119] Mon, 28 May 2007 07:18 Go to previous message
rleishman
Messages: 3724
Registered: October 2005
Location: Melbourne, Australia
Senior Member
Here is my 3rd ever post on this forum, from a time when I was young and enthusiastic rather than old and lazy.

It may or may not help, but I still reckon it's too complex to describe in a forum.

Personally, I had the same response when I first read about them. I just didn't get it - it seemed way too complex. I played around with some functions, seeing what happened when I changed or added clauses. When I still didn't get it, I went back over the Oracle doco and tried to apply what they were saying to the SQLs I was writing. Eventually I got it, but I still don't think I could describe it any better than Oracle has in the manual.

Ross Leishman
Previous Topic: Materialized View question
Next Topic: here is my silly title because i am too lazy to come up with a meaningful title
Goto Forum:
  


Current Time: Sat Dec 03 03:45:21 CST 2016

Total time taken to generate the page: 0.09936 seconds