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 À´´úÌæ
¿´Á¬½
Ïà¹ØÎÊ´ð£º
Ò»°ã¶¼ÊÇÔõô½Ó»îµÄ£¿
ÊÕÈëÔõôÑù
sohu£¿soho£¿
sohu ¿ÉÄÜÊÇsmall office house unit
С°ì¹«ÊÒ£¬°Ñ¼Ò±ä³Éµ¥Î»¡£
È¥Íþ¿ÍÍø°¡,ºÜ¶à¸öÄØ,»¹ÓÐÍâ°üµÄÍøÕ¾
ѧϰѧϰ¡£
ÏÖÔÚDelphi×ö¶«Î÷²»ÐÐÁË,´¦ÓÚÌÔÌ×´ ......
³¡¾°ÈçÏ£º
¿Í»§°Ñ±¸·ÝºÃµÄÊý¾Ý¿â£¬·¢¸øÎÒ£¬ÎÒÔÚ±¾»ú»¹Ôºó£¬ÔËÐÐдºÃµÄ´æ´¢¹ý³Ì£¬±È½Ï¿ì£¬²¢ÇÒÔÚʵʩÄDZßÔËÐÐͬÑù±È½Ï¿ì¡£µ«Êǵ±ÊµÊ©ÔÚ¿Í»§ÄDZßÔËÐеÄʱºòËٶȾͷdz£µÄÂý£¬Ê±¼ä³¬³öÁ˳ÌÐòµÄʱ¼äÏÞÖÆ¡£Ô¶³ÌÔÚ¿Í»§ÄÇ ......
СµÜ£¬×î½üҪתÐÐÈ¥×öoracle¿ª·¢ÁË£¬ÓÉÓÚ´óѧ±Ïҵʱ£¬×ßÁ˸öÍä·£¬ÏÖÔÚºÜСÐÄ£¬ÎÊÏ£¬×öPL/SQLÓÐûÓÐǰ;£¿£¿£¿
µ±È»ÎÒ˵µÄÕâ¸öǰ;ÊÇÖ¸ ÒÔºóÒªÌø²Û£¬Êг¡¶ÔÕâÑùµÄÈ˲ŵÄÐèÇóÁ¿´ó²»´ó£¿£¿
3q ÄÇ¿´À´»¹Ö»ÄÜÏȽӴ ......
±í
id bh
1 10
2 11
3 12
4 15
5 16
6 22
7 25
8 26
9 27
10 28
½«bh°´Á¬Ðø·Ö¶Î³öÀ´·µ»Ø×Ö·û´®£º
10~12£¬15~16£¬22£¬25~28
SQL code:
declare @t tabl ......
select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001'
ÉÏÃæÒ»¸ö¼òµ¥µÄSQL,Ö´ÐÐʱ¼ä2.6à ......