oracle analytical functions

select count(*) over (partition by [column_names])
, row_number over (partition by [column_names] order by [column_names]
from table

Written by Knilluz on 23 June 2010 at 08:44