摘要： /* Formatted on 2012-02-07 오후 4:51:00 (QP5 v5.149.1003.31008) */SELECT * FROM ( SELECT a.lot_id, a.shift_start_timekey, a.event_name, a.old_oper_code, a.oper_code, '-', LAG (old_oper_code, 2) OVER (ORDER BY lot_id, event_timekey) PREVIOUS_2, LAG (old_oper_code, 1) OVER (ORDER BY lot_id, even 阅读全文