Re: SQL - ROWNUM

argh!

Research, research, research, give up and get back to work and right after 
you do Chuck or someone comes out with the answer.

Remember these terms:
OLAP stands for On Line Analytical Processing, OLAP
"Expressions", not built in function, not summary function, not aggregate 
function, not table function
ROW_NUMBER

numbering-specification
|--ROW_NUMBER--(--)--OVER--(--+-------------------------+--+---------------------+--)--|
                              '-window-partition-clause-' 
'-window-order-clause-' 


select row_number() over (order by colb asc) as number, 
cola, colb, colc 
from qtemp.mytable 
where cola is not null 
order by colb 
 NUMBER   COLA           COLB            COLC
      1    B                2               3
      2    A               65               1
      3    D               72               2
      4    C              101               4


Rob Berendt