SQL How to remove duplicates within select query?

Viewed 150068

I have a table which looks like that:

alt text

As You see, there are some date duplicates, so how to select only one row for each date in that table?

the column 'id_from_other_table' is from INNER JOIN with the table above

7 Answers
Related