12 Replies Latest reply: Jan 25, 2013 2:06 AM by avish16 RSS

    SQL -Condition required solution

    Anbarasan-Oracle
      Hi

      i have table T_MAK
      --------------------------------------------------
      NAME GROUP
      Raj MKTDEV:MKTING
      arun MKTDEV
      anil MKTING
      king PRODE
      ------------------------------------------------------------
      I am trying to filter like
      SELECT NAME FROM T_MAK WHERE GROUP LIKE OR IN (MKTDEV:MKTING)..then this both contains name should display
      final out put like
      -----------
      NAME
      Raj
      arun
      anil
      --------------
      Please help out the query..