How to get Oupt Put like

• suresh0534

  SSCommitted

  Points: 1966

  More actions

  November 20, 2015 at 3:40 pm

  #151446

  Hi,

  I have table data below like this:

  CNAME ID Code

  A 1000 CS

  B 1000 CS

  B 1000 DS

  B 1000 ES

  C 1002 CS

  D 1002 CS

  E 1000 CS

  F 1010 CS

  CName must Contain Code "CS" and another CName also if Contains "CS" and Other Codes "DS","ES"..etc.

  Then this both Cname should not get in out put.

  For Above Sample Table OutPut sholud Contain Like:

  CNAME ID Code

  C 1002 CS

  D 1002 CS

  F 1010 CS

  Thanks,