Hi! I am always mixed up between this stuff and i need it to be clear for something i need to do.

I have a table with tasks in it. the same task can be there more than 1 time. So i need them to be unique (group by, distinct?!?!) when i do my select query. But the problem is that i need the rest of the fields associated with this task to be shown­. I tried with distinct but it applies to all fields in the select statement from what i've understand. so how can i make this work. I hope im clear enough!

thanks