title: How to update all rows except one row out of many satisfying the given condition?
body: <p>I have a scenerio where i have to update all the rows but one out of many rows.Say I have a table like </p>
  
  <pre><code>__________________________________________________________
  |COlA         | COLB     | COLC    |  COLD   |   COLE  |
  -----------------------------------------------------------
  |Equipment SI | ADD INFO | MERGE   | Notes   |    Y    |
  |Equipment SI | Active   | MERGE   | Notes   |    Y    |
  |Equipment SI | ORIGINAL | MERGE   | Notes   |    Y    |
  |Fastening    | ADD INFO | MERGE   | Notes   |    Y    |
  |Fastening    | Active   | MERGE   | Notes   |    Y    |
  |Electonics   | ADD INFO | MERGE   | Notes   |    Y    |
  |Electonics   | Active O | MERGE   | Notes   |    Y    |
  |Electonics   | ORIGINAL | MERGE   | Notes   |    Y    |
  |Electonics   | Nominated| MERGE   | Notes   |    Y    |
  |Fiber        | ADD INFO | MERGE   | Notes   |    Y    |
  |Fiber        | ADD INFO | MULTI   | Notes   |    Y    |
  |Fiber        | ADD INFO | KILO    | Notes   |    Y    |
  </code></pre>
  
  <p>Now i need to get the ouput like </p>
  
  <pre><code>__________________________________________________________
  |COlA         | COLB     | COLC    |  COLD   |   COLE  |
  -----------------------------------------------------------
  |Equipment SI | ADD INFO | MERGE   | Notes   |    Y    |
  |Equipment SI | Active   | MERGE   | Notes   |    N    |
  |Equipment SI | ORIGINAL | MERGE   | Notes   |    N    |
  |Fastening    | ADD INFO | MERGE   | Notes   |    Y    |
  |Fastening    | Active   | MERGE   | Notes   |    N    |
  |Electonics   | ADD INFO | MERGE   | Notes   |    Y    |
  |Electonics   | Active O | MERGE   | Notes   |    N    |
  |Electonics   | ORIGINAL | MERGE   | Notes   |    N    |
  |Electonics   | Nominated| MERGE   | Notes   |    N    |
  |Fiber        | ADD INFO | MERGE   | Notes   |    Y    |
  |Fiber        | ADD INFO | MULTI   | Notes   |    Y    |
  |Fiber        | ADD INFO | KILO    | Notes   |    Y    |
  </code></pre>
  
  <p>I'm trying to update the <code>COLE</code> to 'N'(Except one row) from 'Y' .<code>COLA,COLD,COLE</code> should be same to update that particular set. If any row(COLA,COLC,COLD)combination has only one 'Y' then i should not update anything(Fiber in my sample data).I have to update the entire table. Can someone help me on this. Should i create a function and loop through it? In that also how to update only one row?</p>