Çó×ܺ͵ÄSQLÓï¾ä

´ó¼ÒºÃ£¬×ÉѯSQLÓï¾ä£¬ ÓÐÒ»¸öÊý¾Ý¿âÀïÃæÓÐÒ»Õűítable;×ֶηֱðÊÇÉÌÆ·±àºÅ(var),ÉÌÆ·ÊýÁ¿(int),ÉÌÆ·µ¥¼Û(money)±íÀïÃæÒ»¹²ÓÐnÌõ¼Ç¼£¬n>50£¬ÏÖÒªÇóÕâÕűíµÄ×ܽð¶î£¬Ò²¾ÍÊǵÚÒ»ÐеÄÉÌÆ·ÊýÁ¿*µÚÒ»ÐеÄÉÌÆ·µ¥¼Û+µÚ¶þÐеÄÉÌÆ·ÊýÁ¿*µÚ¶þÐеÄÉÌÆ·µ¥¼Û+¡­¡­¡­¡­¡­¡­+µÚnÐеÄÉÌÆ·ÊýÁ¿*µÚnÐеÄÉÌÆ·µ¥¼Û=×ܽð¶î£»
ÇóSQLÓï¾ä,лл

---

SQL code:
select
sum(ÉÌÆ·ÊýÁ¿*ÉÌÆ·µ¥¼Û) as ×ܽð¶î
from
tb

---

SQL code:
select
sum(isnull(ÉÌÆ·ÊýÁ¿,0)*isnull(ÉÌÆ·µ¥¼Û,0)) as ×ܽð¶î
from
tb

---

SQL code:

select ÉÌÆ·±àºÅ,sum(isnull(ÉÌÆ·ÊýÁ¿,0)*isnull(µ¥¼Û,0)) as ×ܽð¶î
from table
group by ÉÌÆ·±àºÅ

---

ÒýÓÃ

SQL codeselectsum(isnull(ÉÌÆ·ÊýÁ¿,0)*isnull(ÉÌÆ·µ¥¼Û,0))as ×ܽð¶îfrom
tb

..

---

¸Ðл¸÷λ¸ã¶¨²»¹ý»¹ÓиöÎÊÌâÏë¼ÌÐøÇë½Ì£¬Èç¹ûÎÒֻȡǰ10ÐеÄÊý¾ÝµÄ³Ë»úµÄºÍÄØ£¡ Óï¾äÓ¦¸ÃÈçºÎд

---

SELECT ÉÌÆ·±àºÅ,SUM(ISNULL(ÉÌÆ·ÊýÁ¿,0)*ISNULL(µ¥¼Û,0)) as ×ܽð¶î from TB GROUP BY ÉÌÆ·±àºÅ

---

SELECT TOP 10 ÉÌÆ·±àºÅ,SUM(ISNULL(ÉÌÆ·ÊýÁ¿,0)*ISNULL(µ¥¼Û,0)) as ×ܽð¶î from TB GROUP BY ÉÌÆ·±àºÅ

---

SQL code

---

Code highlighting produced by Actipro CodeHighlighter (freewar