title: SQL How to remove duplicates within select query?
body: <p>I have a table which looks like that:</p>
  
  <p><img src="https://i.stack.imgur.com/uG4S3.jpg" alt="alt text"></p>
  
  <p>As You see, there are some date duplicates, so how to select only one row for each date in that table?</p>
  
  <p>the column 'id_from_other_table' is from INNER JOIN with the table above</p>