SQL查询每个商家只显示一条数据

SELECT
 top 10 *
FROM
  shop_info_main_data AS T
WHERE
  infoId
IN
  (SELECT TOP 1 infoId FROM shop_info_main_data WHERE memberId=T.memberId order by infoid desc )
order by infoid desc