我现在要实现的语句是 查出不重复的用户id 然后按价格排序,但问题是Distinct和order by不能同时用,后来查了一下,
SELECT distinct user_id,product_price FROM rhdianpu.products GROUP BY user_id,product_price ORDER BY Min(product_price)但是这样查出来的结果会有重复的,想问一下到底应该怎么写?
SELECT distinct user_id,product_price FROM rhdianpu.products GROUP BY user_id,product_price ORDER BY Min(product_price)但是这样查出来的结果会有重复的,想问一下到底应该怎么写?
SELECT [id]
,count(id)
FROM rhdianpu.products group by id order by id
SELECT USER_ID,Min(product_price)
FROM rhdianpu.products GROUP BY user_id ORDER BY Min(product_price)