sql如何把一个查询结果当作一个表来

select * from

(

SELECT SUM(NUM_QNTY4) AS sumNum, NUM_LINKID

FROM RW_STORE_QUNTY

GROUP BY NUM_LINKID

) as A

要把子查询用括号括起来，并且起一个别名，as xxx。

参考：http://www.laorenka.com/112390.html