SELECT * FROM
( SELECT ROW_NUMBER () OVER ( PARTITION BY markuser ORDER BY MarkTime ASC ) AS rid ,
* FROM
( SELECT his . markuser , MarkTime , COUNT ( 1 ) AS num
-- his.markuser
FROM liebowh . StoreHouse . ReturnGoodsdetail detail
LEFT JOIN CallCentre . CC . ReturnGoodsInfoHistory his ON detail . returngoodsid = his . returngoodid
GROUP BY his . markuser , MarkTime ) aa
) bb
WHERE rid = 1 AND markuser = 471
( SELECT ROW_NUMBER () OVER ( PARTITION BY markuser ORDER BY MarkTime ASC ) AS rid ,
* FROM
( SELECT his . markuser , MarkTime , COUNT ( 1 ) AS num
-- his.markuser
FROM liebowh . StoreHouse . ReturnGoodsdetail detail
LEFT JOIN CallCentre . CC . ReturnGoodsInfoHistory his ON detail . returngoodsid = his . returngoodid
GROUP BY his . markuser , MarkTime ) aa
) bb
WHERE rid = 1 AND markuser = 471