Rate this post by selecting a number. 1 is the worst and 5 is the best.

Author Message   Symbol_of_king Kurra Bewarse Username: Symbol_of_king Post Number: 2121 Registered: 12-2005 Posted From: 70.192.193.239 Rating: N/A Votes: 0 Posted on Wednesday, July 24, 2013 - 5:15 pm:    select company,activity ? first_value(activity) over (partition by company order by activity desc) updt_activity, sum(amount) over (partition by company) updt_amount from table_XYZ Something similar to above should work...fyi..i am not 100% sure.