挺简单的题,居然没做出来
SELECT uid,shopid from table_name a INNER JOIN
(SELECT MIN(start_time) as time FROM `test` GROUP BY uid) as b
on a.start_time = b.time
今天写个答案
挺简单的题,居然没做出来
SELECT uid,shopid from table_name a INNER JOIN
(SELECT MIN(start_time) as time FROM `test` GROUP BY uid) as b
on a.start_time = b.time
今天写个答案