Can Someone Help me with OLAP?

rockdave35 · #1 (**permalink**) 07-23-09, 16:31

DB2 noob here and I have avoided learning OLAP too long. I've read a few tutorials, and the functions are still completely alien to me.

So I tried to code one with our existing data to get an idea of how it functions. Great, syntax errors. I can't figure out what I'm doing wrong. Here is my code:

Code:


SELECT   recip_ssn_mbr, 
         ANTY_PYMT_NET_AMT,
         ROW_NUMBER() over (order by ANTY_PYMT_NET_AMT desc) as test 
FROM     DSNP.PR01_T_ANTY_PYMT

I get "unexpected token ( was found. Any idea what I'm missing? Granted, I don't have a clue what the Row Number would show me. What does "over" mean anyways?