SELECT
a.id id,
a.uid uid,
SUBSTRING_INDEX(
group_concat(a.price ORDER BY a.price DESC),
',',
1
) as price
from
ha_app_auctions a
where
a.txnId = 13
GROUP BY a.uid
a.id id,
a.uid uid,
SUBSTRING_INDEX(
group_concat(a.price ORDER BY a.price DESC),
',',
1
) as price
from
ha_app_auctions a
where
a.txnId = 13
GROUP BY a.uid