3 Replies Latest reply on Feb 18, 2013 2:39 PM by user9542267

    Query with IN clause

    user9542267
      Hi,
      Is this query possible?
      select *
      from cars c
      where c.car_class_id = 6
      and c.car_id in (case when 1=1 then (11,12,13)
      else (15,16,17) end)

      I would like to filter the list of cars id base on a condition.
      Thanks