Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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 À´´úÌæ


¿´Á¬½


Ïà¹ØÎÊ´ð£º

sqlÓï¾ä¶à±í¶à×ֶβéѯ - MS-SQL Server / »ù´¡Àà

ÎÒÓжà¸ö±íA B C ½á¹¹ÊÇÒ»ÑùµÄ£¬¶¼ÓÐ2¸ö×Ö¶ÎnameºÍcontent,ÎÒÒªËÑË÷ËùÒÔ±íËùÓÐ×Ö¶ÎÖаüº¬¡°Öйú¡±µÄÄÚÈÝ Õâ¸öSQLÓï¾äÔõôд 

ÈçºÎ½«¶à¸ö±íµÄ²éѯ½á¹ûÁ¬³ÉÒ»¸ö±í Õâ¸öSQLÓï¾äÔõôд ±íµÄ½á¹¹ÊÇÒ»ÑùµÄ
ÀýÈç£ ......

Asp+sql serverÎÊÌâ - Web ¿ª·¢ / ASP

ÎÒÒ»¸öÏîÄ¿£¬Óиö²åÈë²Ù×÷£¬¾ßÌåÊÇÕâÑùµÄ£º
ÎÒÓнø»õÐÅÏ¢±í¡£ÔÚ³ö»õʱѡÔñÏàÓ¦µÄ½ø»õÐÅÏ¢£¬ÊäÈëÊýÁ¿£¬Ñ¡Ôñ²¿Ãź󣬵㱣´æ°´Å¥£¬ÓÉÓÚÍøÂçÑÓʱ£¬µãÒ»ÏÂûÓз´Ó³£¬ÓÚÊÇÓû§¾ÍÓÖµãһϣ¬µ¼ÖÂÒ»´Î²åÈëÁËÁ½Ìõ¼Ç¼:
Àý£º ......

Çë½ÌÏ£¬ÓÃDELPHI×öSOHUµÄ - Delphi / ·Ç¼¼ÊõÇø

Ò»°ã¶¼ÊÇÔõô½Ó»îµÄ£¿
ÊÕÈëÔõôÑù
sohu£¿soho£¿

sohu ¿ÉÄÜÊÇsmall office house unit
С°ì¹«ÊÒ£¬°Ñ¼Ò±ä³Éµ¥Î»¡£

È¥Íþ¿ÍÍø°¡,ºÜ¶à¸öÄØ,»¹ÓÐÍâ°üµÄÍøÕ¾

ѧϰѧϰ¡£

ÏÖÔÚDelphi×ö¶«Î÷²»ÐÐÁË,´¦ÓÚÌÔÌ­×´ ......

Çë½ÌsqlÓï¾ä¡£ - Oracle / ¿ª·¢

ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
  ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......

SQLÈçºÎÓÅ»¯ÎÊÌâ - MS-SQL Server / ÒÉÄÑÎÊÌâ

½ñÌì×öÁËÒ»¸ö´æ´¢¹ý³Ì   »·¾³ÊÇSQL2000Êý¾Ý¿â  
´óÖÂÈçÏÂ
½¨Á¢ÁÙʱ±í
¶¨ÒåÔ±¹¤Óαê
        Ñ­»·Ô±¹¤£¨ÊôÓÚ1¸ö¹«Ë¾)  
        ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ