SELECT *
FROM( SELECT ROW_NUMBER()OVER(PARTITION BY m_type order by m_id) AS Num,*
FROM m_data) as temp
WHERE Num <= 100
转载于:https://www.cnblogs.com/qisheng/archive/2012/12/20/2825998.html
SELECT *
FROM( SELECT ROW_NUMBER()OVER(PARTITION BY m_type order by m_id) AS Num,*
FROM m_data) as temp
WHERE Num <= 100
转载于:https://www.cnblogs.com/qisheng/archive/2012/12/20/2825998.html