SQLÓï¾äдÈëdelphiµÄadoquery.sql.addÖÐ
ÈçÌ⣬ÎÒÏë°ÑÏÂÃæÕâ¶ÎsqlÓï¾äдÔÚadoqueryÖУ¬µ«ÊÇ×ÜÊÇ´¦Àí²»ºÃµ¥ÒýºÅµÄÎÊÌâ
select b.Ô²ÄÁÏÃû³Æ,a.²ÄÁϺÅ,ʱ¼ä,Èë¿âÊýÁ¿ = sum(Èë¿âÊýÁ¿),³ö¿âÊýÁ¿ = sum(³ö¿âÊýÁ¿)
from
(
select '²ÄÁϺÅ' = case when isnull(ÔÁÏÈë¿â±í.²ÄÁϺÅ,'') = '' then ÔÁϳö¿â±í.²ÄÁϺŠelse ÔÁÏÈë¿â±í.²ÄÁϺŠend,
'ʱ¼ä' = case when isnull(ÔÁÏÈë¿â±í.Èë¿âʱ¼ä,'') = '' then convert(char(10),ÔÁϳö¿â±í.³ö¿âʱ¼ä,120)
else convert(char(10),ÔÁÏÈë¿â±í.Èë¿âʱ¼ä,120) end,
'Èë¿âÊýÁ¿' = isnull(Èë¿âÊýÁ¿,0),
'³ö¿âÊýÁ¿' = isnull(³ö¿âÊýÁ¿,0)
from ÔÁÏÈë¿â±í full outer join ÔÁϳö¿â±í
on ÔÁÏÈë¿â±í.²ÄÁϺŠ= ÔÁϳö¿â±í.²ÄÁϺÅ
and convert(char(10),Èë¿âʱ¼ä,120) = convert(char(10),³ö¿âʱ¼ä,120)
and ÔÁÏÈë¿â±í.²Ö¿âºÅ = ÔÁϳö¿â±í.²Ö¿âºÅ
) a,Ô²ÄÁÏÐÅÏ¢±í b
where ʱ¼ä is not null
and b.²ÄÁϺÅ=a.²ÄÁϺÅ
and ʱ¼ä>='2010-01-23'
and ʱ¼ä <='2010-01-24'
group by Ô²ÄÁÏÃû³Æ,ʱ¼ä,a.²ÄÁϺÅ
order by ʱ¼ä,a.²ÄÁϺÅ
and ʱ¼ä>='2010-01-23'
and ʱ¼ä <='2010-01-24'Õâ¶ÎÎÒ»¹ÏëÓÃ
and ʱ¼ä>=datetimePicker1.datetime
and ʱ¼ä <=datetimePicker2.datetime À´´úÌæ
¿´Á¬½
Ïà¹ØÎÊ´ð£º
ÎÒÓжà¸ö±íA B C ½á¹¹ÊÇÒ»ÑùµÄ£¬¶¼ÓÐ2¸ö×Ö¶ÎnameºÍcontent,ÎÒÒªËÑË÷ËùÒÔ±íËùÓÐ×Ö¶ÎÖаüº¬¡°Öйú¡±µÄÄÚÈÝ Õâ¸öSQLÓï¾äÔõôд
ÈçºÎ½«¶à¸ö±íµÄ²éѯ½á¹ûÁ¬³ÉÒ»¸ö±í Õâ¸öSQLÓï¾äÔõôд ±íµÄ½á¹¹ÊÇÒ»ÑùµÄ
ÀýÈç£ ......
ÎÒÒ»¸öÏîÄ¿£¬Óиö²åÈë²Ù×÷£¬¾ßÌåÊÇÕâÑùµÄ£º
ÎÒÓнø»õÐÅÏ¢±í¡£ÔÚ³ö»õʱѡÔñÏàÓ¦µÄ½ø»õÐÅÏ¢£¬ÊäÈëÊýÁ¿£¬Ñ¡Ôñ²¿Ãź󣬵㱣´æ°´Å¥£¬ÓÉÓÚÍøÂçÑÓʱ£¬µãÒ»ÏÂûÓз´Ó³£¬ÓÚÊÇÓû§¾ÍÓÖµãһϣ¬µ¼ÖÂÒ»´Î²åÈëÁËÁ½Ìõ¼Ç¼:
Àý£º
......
Ò»°ã¶¼ÊÇÔõô½Ó»îµÄ£¿
ÊÕÈëÔõôÑù
sohu£¿soho£¿
sohu ¿ÉÄÜÊÇsmall office house unit
С°ì¹«ÊÒ£¬°Ñ¼Ò±ä³Éµ¥Î»¡£
È¥Íþ¿ÍÍø°¡,ºÜ¶à¸öÄØ,»¹ÓÐÍâ°üµÄÍøÕ¾
ѧϰѧϰ¡£
ÏÖÔÚDelphi×ö¶«Î÷²»ÐÐÁË,´¦ÓÚÌÔÌ×´ ......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
½ñÌì×öÁËÒ»¸ö´æ´¢¹ý³Ì »·¾³ÊÇSQL2000Êý¾Ý¿â
´óÖÂÈçÏÂ
½¨Á¢ÁÙʱ±í
¶¨ÒåÔ±¹¤Óαê
Ñ»·Ô±¹¤£¨ÊôÓÚ1¸ö¹«Ë¾)
......