Query Analysis

[#1]

Hi,

Can anyone explain following query with example in qlikview

(select replace(concat(' ',cast(timestamp as varchar(19))),'-','/')

from pos.pos_audit_trail

where log_id =

(select max(log_id)

from pos.pos_audit_trail

where task_name like 'POS_OM_OrderBooking'

and bpm_order_id = p.bpm_order_id and task_event='COMPLETE')

and log_id>

(select max(log_id)

from pos.pos_audit_trail

where task_name like 'POS_OM_OrderBooking'

and bpm_order_id = p.bpm_order_id

and (task_event='INITIATE' or task_event='CLAIM')))