Á½¾äSQL²¢Ò»¾ä,ÓÐÎÊÌâ. - MS-SQL Server / »ù´¡Àà
µÚÒ»¾ä:
select ht.gfdm,gfdm.gfmc,gfdm.lb ,sum(jh.htdj*jh.htsl)as je
from ht left join gfdm on ht.gfdm=gfdm.gfdm
join jh on ht.htbh=jh.hth
and ht.htbh not like'del%' and ht.ht_xy_flag='ht'
and ht.lkc_flag=0 and jh.hth<>'cancel' and jh.id=ph
and ht.qdrq between '2008-01-01' and '2008-12-31'
group by ht.gfdm ,gfdm.gfmc,gfdm.lb order by je desc
µÚ¶þ¾ä:
select ht.gfdm,gfdm.gfmc,gfdm.lb, sum(ysd.yssl*ysd.htdj)as je
from ht left join gfdm on ht.gfdm=gfdm.gfdm
join ysd on ht.htbh=ysd.htbh
and ht.htbh not like'del%' and ht.ht_xy_flag='ht'
and ht.lkc_flag=1
and ht.qdrq between '2008-01-01' and '2008-12-31'
group by ht.gfdm ,gfdm.gfmc,gfdm.lb order by je desc
ºÏ²¢
select ht.gfdm,gfdm.gfmc,gfdm.lb,
je=sum(case ht.lkc_flag when 0 then jh.htdj*jh.htsl else 0 end)
,lkc_je=sum(case ht.lkc_flag when 1 then ysd.yssl*ysd.htdj else 0 end)
from ht left join gfdm on ht.gfdm=gfdm.gfdm
join ysd on ht.htbh=ysd.htbh
join jh on ht.htbh=jh.hth
where ht.qdrq between '2008-01-01' and '2008-12-31'
and ht.htbh not like'del%' and ht.ht_xy_flag='ht'
group by ht.gfdm ,gfdm.gfmc,gfdm.lb order by je desc
ÎÒ°ÑÁ½¾äÇ°Á½¾ä²¢³ÉÒ»¾äºó,½á¹û²»¶Ô.Çë¸ßÊÖ°ïÖúÕï¶ÏÒ»ÏÂ,´íÔÚÄÄÀï,лл!
select ht.gfdm,gfdm.gfmc,gfdm.lb ,sum(jh.htdj*jh
Ïà¹ØÎÊ´ð£º
ÎÒÒ»¸öÏîÄ¿£¬Óиö²åÈë²Ù×÷£¬¾ßÌåÊÇÕâÑùµÄ£º
ÎÒÓнø»õÐÅÏ¢±í¡£ÔÚ³ö»õʱѡÔñÏàÓ¦µÄ½ø»õÐÅÏ¢£¬ÊäÈëÊýÁ¿£¬Ñ¡Ôñ²¿Ãź󣬵㱣´æ°´Å¥£¬ÓÉÓÚÍøÂçÑÓʱ£¬µãÒ»ÏÂûÓз´Ó³£¬ÓÚÊÇÓû§¾ÍÓÖµãһϣ¬µ¼ÖÂÒ»´Î²åÈëÁËÁ½Ìõ¼Ç¼:
Àý£º
......
ÏÖÔÚÓÐÁ½ÕÅ±í£ºÎÄÕÂÖ÷±íA(articleId,articleTitle)£¬ÎÄÕÂÆÀÂÛ±íB(commentId,articleId,commentTitle)
ÏÖÔÚÎÒÏëʵÏÖÕâÑùµÄ¹¦ÄÜ£ºÁгöÎÄÕÂÁÐ±í£¬ÆäÖÐÿƪÎÄÕ±êÌâÏÂÃæÁгö´ËÎÄÕµÄÇ°2¸öÎÄÕÂÆÀÂÛ£¬ÇëÎÊsqlÓï¾äÔõôд°¡ ......
select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001'
ÉÏÃæÒ»¸ö¼òµ¥µÄSQL,Ö´ÐÐʱ¼ä2.6à ......
ÄÄλÈÊÐÖÓй¦ÄÜÍêÕû¿ÉÓõÄSQLÏÂÔصØÖ·ÄØ£¬ÎÒÓÐÒ»¸öµØÖ·£¬µ«ÊÇ°²×°ºó¹¦Äܲ»ÍêÕûÎÞ·¨Ê¹Óã¨Ã»ÓзþÎñÆ÷£©ÎÒÖªµÀµÄµØÖ·ÊÇ
http://down.xlylw.com/downlist/s_66_1.html
¿´À´£¬ÄãÖ»Äܵ½ÍøÉÏ×Ô¼ºËÑË÷ÁË!
×Ô¼º¶¯ÊÖ¾Í¿É ......