Re: Query Help

AZNewsh wrote:
> That will not 'get me going'
>
>
> That is not what i asked, I asked for help with the conceptual query
> and what the heck is top posting?
>
>
> On Jan 25, 2:04 pm, "Ed Prochak" <edproc..._at_gmail.com> wrote:

>> On Jan 25, 1:26 pm, "AZNewsh" <g..._at_dana.ucc.nau.edu> wrote:
>>
>>> Thanks but I don't think that does the same thing unless I am reading
>>> it wrong:
>>> http://www.oracle.com/technology/oramag/oracle/06-nov/o66asktom.htmlPlease DON'T TOP POST!
>> Look at generating a pivot tablehttp://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:7...
>>
>> That should get you going.

Top posting is what you just did. This forum reads from top to the bottom. When replying scroll to the bottom and then reply ... do NOT post at the top.

We sent you to the solution. But if you prefer concept ok.

Use an analytic function with LAG or LEAD integrated with either CASE or DECODE to pivot the data.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org