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
转载于:https://www.cnblogs.com/junjun898/archive/2010/12/17/1909354.html