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; Èç¹ûÊÇÏȽøÏȳö,½á¹û²»¶Ô. ²»¶ÔÂð£¿ÎҸоõÊÇÏȽøÏȳöѽ£¬½á¹ûûÓÐÎÊÌâѽ£¿ ¹æÔòûÓп´Ã÷°×¡£¡£¡£ ˸ø½²Ã÷°×µã°¡
´ó¼ÒºÃ£¬ÇëÎÊÔÚ±íMÖÐÓÐ×ֶΣºa b c d e ÎÒÏë²é³öÆäÖÐÂú×ãÏÂÃæÈÎÒâÒ»ÏîµÄÊý¾Ý£¬1.×Ö¶Îa µÄÖµ²»ÊÇ ¡®Êé»ò±Ê»ò±¾¡¯ÖÐÈÎÒ»£¬2.aΪÊéµÄʱºò×Ö¶Îb,cÊÇ¿Õ;3.µ±aֵΪ±ÊµÄʱºòdÊÇ¿Õ;4.µ±aΪ±¾µÄʱºòb,d,e¶¼ÊÇ¿Õ;5.È ......
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 ......