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

Sql È¡Êý¾ÝÎÊÌâ

declare @test table(
title varchar(100),--±êÌâ
num decimal(18,6), --ÊýÁ¿
unitqty decimal(18,6) --µ¥Î»
)
insert into @test values('a',100,50)
insert into @test values('b',123,50)
insert into @test values('c',234,60)
insert into @test values('d',120,50)
insert into @test values('e',230,60)

ÎÊÌâÈçÏ£¬ÒªÓÃÒ»¸ösqlʵÏÖ
--³ö200ÊýÁ¿£¬50µ¥Î»µÃµ½µÄ½á¹ûÊÇ
title  num  unitqty
a      100    50
b      100    50
--³ö80ÊýÁ¿£¬50µ¥Î»µÃµ½µÄ½á¹ûÊÇ
title  num  unitqty
a      80    50
--²»Ã÷°×Â¥Ö÷ʲôÒâ˼£¿

--ÕâÒ»µã¹æÔòҲûÓÐ,ºÇºÇ£ºÖ»ÓÐ
select  a title, 100 num, 50 unitqty union all
select b, 100, 50 union all
select a, 80, 50;


Èç¹ûÊÇÏȽøÏȳö,½á¹û²»¶Ô.

ÒýÓÃ
Èç¹ûÊÇÏȽøÏȳö,½á¹û²»¶Ô.

²»¶ÔÂð£¿ÎҸоõÊÇÏȽøÏȳöѽ£¬½á¹ûûÓÐÎÊÌâѽ£¿

¹æÔòûÓп´Ã÷°×¡£¡£¡£
Ë­¸ø½²Ã÷°×µã°¡


Ïà¹ØÎÊ´ð£º

ÇóSQL£¿

´ó¼ÒºÃ£¬ÇëÎÊÔÚ±íMÖÐÓÐ×ֶΣºa b c d e 
ÎÒÏë²é³öÆäÖÐÂú×ãÏÂÃæÈÎÒâÒ»ÏîµÄÊý¾Ý£¬1.×Ö¶Îa µÄÖµ²»ÊÇ ¡®Êé»ò±Ê»ò±¾¡¯ÖÐÈÎÒ»£¬2.aΪÊéµÄʱºò×Ö¶Îb,cÊÇ¿Õ;3.µ±aֵΪ±ÊµÄʱºòdÊÇ¿Õ;4.µ±aΪ±¾µÄʱºòb,d,e¶¼ÊÇ¿Õ;5.È ......

¹ØÓÚgroup byµÄsqlÓï¾ä£¿

  with adod_dict do
    begin
    close;
    commandtext:='select bgqxcode,count(*) wjsl from wscl_wsda_file where wjnd=:tnd group by bgqxcode'; ......

×Ü»áÅöµ½¹ÖµÄÎÊÌ⣬sqlÎÊÌâ

sql2005
select *from v_ddxx where d_sfsc='0' and (g_ssbm='1001' or g_ssbm='1002') and (xxf>0 and  xxfwzf <>0 ),Ö´ÐÐËÙ¶ÈÂýµÄÒªËÀ£¬µ«ÊÇÈç¹û°Ñ(xxf>0 and  ......

sql ÎÊÌâ

PBÖпª·¢µÄ¡£

DateTime startTime=DateTime(em_1.Text)
DateTime endTime=DateTime(em_2.Text)

string sql
sql = dw_1.GetSQLSelect()+"Where (StartTime> '"+startTime+&q ......

sql ÎÊÌâ

DateTime startTime=DateTime(em_1.Text)
DateTime endTime=DateTime(em_2.Text)

string sql
sql = dw_1.GetSQLSelect()+"Where (StartTime> '"+startTime+"') and (EndTime ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ