æç没人åçæåä¸ã
-----------------------------
è¿ä¸ªç¨åæ¥è¯¢å°±å¯ä»¥äºï¼å¦æåµå¥å¾å¤ï¼è¯æä½ çæ°æ®åºè®¾è®¡å¾è¹©èã
ç»ä½ 个ä¾åï¼
----------
SELECT TOP 10
convert(varchar(10),K.ID) as ID,
convert(varchar(20),convert(decimal(18,2),K.SumRealSaleCost)) as SumRealSaleCost,
K.CountRes
from
(
select
ROW_NUMBER() OVER (ORDER BY GetDate()) AS ID,
(sum(M.Sale) over()-sum(M.ReturnSaleCost) over()) as SumRealSaleCost,
count(*) over() as CountRes
from
(
---è¿éä½ ç±ç¨ä»ä¹èåå½æ°å°±ç¨ä»ä¹èåå½æ°ï¼æåªç¨äºä¸ä¸ªç®åçåæ¥è¯¢èå·²ï¼
select
A.Sale,
A.ReturnSaleCost
from ProductStore A
) M
) K
where K.ID >ï¼
--è¿ä¸ªæåºæ好åå页å½æ°ä¸è´ã
ORDER BY K.Sale DESC
--------------------
æå¤å±ä¸ºç±»å转åå±
ä¸é´æ¯æ°æ®é»è¾å±
æå
å±å°±æ¯éåæ建å±
æè¿ç§åæ³å¾å¤äººä¸ç解ï¼æ¬äººååãä½ ç¾åº¦ä¸å°ï¼
---------------------
å¦æLZæ°æ®åºæååºçè¯ï¼å å
¥æçå¢éå§ï¼æ°æ®åºèè´¤åº
温馨提示:答案为网友推荐,仅供参考