title: Return row position - Postgres
body: <p>I return a table with position:</p>
  
  <pre><code>select * 
  from (
      select *, row_number() over() as position 
      from organization
  ) result 
  where data1 = 'Hello';
  </code></pre>
  
  <p>Gives back this, which is correct:</p>
  
  <pre><code>data1 | Hello
  data2 | Joe
  position | 5
  </code></pre>
  
  <p>But when I do:</p>
  
  <pre><code>select position 
  from (
     select *, row_number() over() as position 
     from organization
  ) result 
  where data1 = 'Hello';
  </code></pre>
  
  <p>It returns:</p>
  
  <pre><code>position | 25
  </code></pre>
  
  <p>What am missing here?
  How can I modify this query to return 5?</p>