| analytical sql statements [message #240587] |
Fri, 25 May 2007 04:47  |
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  |
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 #241119 is a reply to message #241073] |
Mon, 28 May 2007 07:02 |
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 |
rleishman
Messages: 3728
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
