- 3/26/04 06:12 pm
-
hmm gribeeju izproveet un explain plaanu pacholeet bet
dabuuju "ORA-00932: inconsistent datatypes: expected INTERVAL got NUMBER"
uz shito CASE:
CASE
WHEN(ev.start_time - LAG(ev.end_time) OVER(ORDER BY ev.start_time) <
10
/ 24
) THEN LAG(ev.ID) OVER(ORDER BY ev.start_time)
ELSE NULL
END AS parent_id