title: trying to select few rows in sql
body: <p>i have a table</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>Id</th>
  <th>Month</th>
  <th>Salary</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>1</td>
  <td>1</td>
  <td>20</td>
  </tr>
  <tr>
  <td>2</td>
  <td>1</td>
  <td>20</td>
  </tr>
  <tr>
  <td>1</td>
  <td>2</td>
  <td>30</td>
  </tr>
  <tr>
  <td>2</td>
  <td>2</td>
  <td>30</td>
  </tr>
  <tr>
  <td>3</td>
  <td>2</td>
  <td>40</td>
  </tr>
  <tr>
  <td>1</td>
  <td>3</td>
  <td>40</td>
  </tr>
  <tr>
  <td>3</td>
  <td>3</td>
  <td>60</td>
  </tr>
  <tr>
  <td>1</td>
  <td>4</td>
  <td>60</td>
  </tr>
  <tr>
  <td>3</td>
  <td>4</td>
  <td>70</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>I was trying to remove some max month in each id . I was trying the following query</p>
  <pre><code>select * from Employee 
   where  id , month not in ( select distinct id, max(Month) over(partition by id ) from Employee)
  </code></pre>
  <p>I cant understand what wrong with this query why cant i do this way. Is there any alternative way for this</p>