SELECT * from
(SELECT ROW_NUMBER() OVER(PARTITION BY O.firstno ORDER BY O.id ASC) AS Row_Index,*
FROM (select OW.*,st.code code2 from busness_product_order_outdata OW
LEFT JOIN (SELECT DISTINCT name,code from base_stock_detail) st
on OW.code = st.code
WHERE orderno = '0000000490' and state2 = 0) O) W
where W.Row_Index=1
查询表——条件是分组的第一个 用ROW_NUMBER() OVER(PARTITION BY O.firstno ORDER BY O.id ASC) AS Row_Index去实现