title: mySQL - Is this query possible
body: <p>I was wondering if it is possible to get this done by a query:</p>
  
  <p>I have a table of bids done on different products</p>
  
  <pre><code>bid_id, product_id, date, price
  </code></pre>
  
  <p>bid_id is an incremented key, 
  product_id is foreign key from another table of product details.</p>
  
  <p>I would like to select all bids that raised the bid price on a product.
  With what I have in this table, can it be done?</p>
  
  <p>Let me try to make my myself clearer: For each product I would like to get all the dibs that raised the price from the previous bid.</p>
  
  <p>For example: If the table contains</p>
  
  <pre><code>1, 12202, "2013-09-08 13:41:45", 120
  2, 17394, "2013-09-08 13:43:32", 250
  3, 12202, "2013-09-08 13:54:11", 170
  4, 12202, "2013-09-08 14:05:37", 210
  </code></pre>
  
  <p>I would like to get lines 3 and 4 as output. (there can be several lines for one product)</p>
  
  <p>Thanks!</p>