SQL How to output without repeats and with quantity?

Question

SQL

We have such a table, and we get it when querying:
SELECT * FROM table WHERE uid=2;

But there are a lot of duplicated rows, I want to display it like this:

Ideology:
- take the minimum id
- combine everything where p (parameters are equal)
- WHERE should work and all fields should be
I know how to do this on C#, but if there is an easy solution, then I prefer SQL.
What options?
Or should you not bother with SQL?
Can eat on SQL a variant, but it will be slow.

Answer 1

GROUP BY