sybase - compute

select col1, col2, col3 from tab order by col1, col2

                 

         compute sum(col3) by col1