OraFAQ Forum: Performance Tuning » How the Query works

Home » RDBMS Server » Performance Tuning » How the Query works

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How the Query works [message #348973]

Thu, 18 September 2008 07:51

basmraj
Messages: 8
Registered: September 2008

Junior Member

Hi,

Anyone explain how this query works...

select Report,BU,Sub_bu,file_order,total,
case
when sub_bu='ISS'
then max(case when sub_bu='ESS' then total end) over(partition by report)
when sub_bu='TS'
then max(case when sub_bu='Services' then total end) over(partition by report)
end as total_bu
from tsg

thanks

Report message to a moderator