Çó Sql Óï¾äÔõôд£¡ - .NET¼¼Êõ / ASP.NET
ÓÐÁ½Õűí
tb1 id name
01 ÕÅÈý
02 ÀîËÄ
tb2 id riqi renwu
01 2010.01.01 aaa
01 2010.02.02 bbb
02 2010.03.01 ccc
02 2010.04.02 ddd
ÎÒÏëµÃµ½ÏÂÃæµÄ½á¹û
01 ÕÅÈý 2010.01.01 aaa
02 ÀîËÄ 2010.03.01 ccc
Ò²¾ÍÊDzéѯtb1±íÖÐËùÓеÄÐÅÏ¢£¬²¢ÇÒ½«tb2±íÖÐ×îÔçµÄÈÎÎñ²éѯ³öÀ´
ÏÂÃæÊÇÎÒµÄÏë·¨£¬µ«ÊÇand ºóÃæµÄÌõ¼þÔõôд£¬
select tb1.id,tb1.name,tb2.riqi,tb2.renwu from tb1 left join tb2 on tb1.id=tb2,id and £¿
select tb1.*, riqi from tb1 left join
(select min(riqi) as riqi from tb2 group by id) as tb2 on tb2.id = tb1.id
¸÷λ°ï°ï棡£¡£¡£¡
Ìõ¼þÖ»ÒªÈÃËüÃǵÄÖ÷¼üÏàµÈ
¸öÈ˾õµÃ¸É´à·ÖÁ½¾äдµÃÁË£¬Õâôд²»ÀÛ°¡£¿
лл¸÷λ£¡£¡£¡
SQL code:
select t1.id, t1.name, t2.riqi, t2.renwu from @t1 t1, @t2 t2
where t1.id=t2.id and datepart(day, cast(riqi as smalldatetime))=1
ÔÙ²¹Ò»¸ö£¬µ±È»Ë¼Â·ÊÇÒ»ÑùµÄ£¬ÎÒÕæ²»ÖªµÀÕâ¸ö½á¹û¸ÃÓÃÔõÑùµÄÌõ¼þÀ´ÏÞÖÆ£¬Õâ¸ö·¢Ìûʱû˵Çå¡£
SQL code
Co
Ïà¹ØÎÊ´ð£º
ÎÒÒ»¸öÏîÄ¿£¬Óиö²åÈë²Ù×÷£¬¾ßÌåÊÇÕâÑùµÄ£º
ÎÒÓнø»õÐÅÏ¢±í¡£ÔÚ³ö»õʱѡÔñÏàÓ¦µÄ½ø»õÐÅÏ¢£¬ÊäÈëÊýÁ¿£¬Ñ¡Ôñ²¿Ãź󣬵㱣´æ°´Å¥£¬ÓÉÓÚÍøÂçÑÓʱ£¬µãÒ»ÏÂûÓз´Ó³£¬ÓÚÊÇÓû§¾ÍÓÖµãһϣ¬µ¼ÖÂÒ»´Î²åÈëÁËÁ½Ìõ¼Ç¼:
Àý£º
......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
ÈçºÎÔÚSQL2005ÖÐÉ趨¶¨Ê±×÷Òµ£¬±ÈÈç˵¶¨Ê±ÇåÀíijЩ±íµÄÊý¾Ý£¬
»òÕßÊǶ¨Ê±µÄ½«Ä³Ð©±íµÄÊý¾Ýµ¼³öexcel£¡
ÔÚÏߵȴý£¬¼±¼±¼±£¬×îºÃÊÇÏêϸ²½Ö裡
֮ǰÎÒ×öµÄ×÷ÒµÓеãÎÊÌ⣡
°ïUP
²Î¿¼:http://hi.baidu.com/toiota ......
C# code:
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Runtime.InteropServices;
nam ......