Find distinct from multiple columns [closed]

Question

I have 2 columns called price and PID in database called seatinginfo. Both columns will have multiple of the same values like

pid 1,1,1,1,2,2,2,2,2,2,2,3,3,3,3,3
price 10,10,30,40,60,80,70,90,90,90,90 etc

I'm looking to make a query that will give me a list of all unique prices and pick just 1 or the max connected pid. So example I only want one price,pid like 10,1 30,1 40,1 60,2 etc

Thanks

Answer 1

This is probably as simple as basic aggregation. Something like this should work based on the pretty vague details.

select price
    , max(pid)
from YourTable
group by price