Query

• jagjitsingh

  Ten Centuries

  Points: 1059

  More actions

  December 14, 2021 at 5:00 pm

  Go to Answer

  #3963569

  Hi

  I have below data and i want if both Sale & Purchase = 'N' then that record should not be displayed

  Item   Name Purchase Sale

  1          AB           Y             N

  2         BC           N             Y

  3          DE          N            N

  In below case 3 record should not get displayed

  Thanks

• Jonathan AC Roberts

  SSCoach

  Points: 18354

  More actions

  December 14, 2021 at 5:08 pm

  Answer

  #3963574

  SELECT *
    FROM myTable
   WHERE NOT(Sale = 'N' AND Purchase = 'N')
  
  SELECT *
    FROM myTable
   WHERE (Sale <> 'N' OR Purchase <> 'N')