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

Çó 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


Ïà¹ØÎÊ´ð£º

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

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

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

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

MS SQL×÷ÒµÎÊÌâ - MS-SQL Server / Ó¦ÓÃʵÀý

ÈçºÎÔÚSQL2005ÖÐÉ趨¶¨Ê±×÷Òµ£¬±ÈÈç˵¶¨Ê±ÇåÀíijЩ±íµÄÊý¾Ý£¬
»òÕßÊǶ¨Ê±µÄ½«Ä³Ð©±íµÄÊý¾Ýµ¼³öexcel£¡
ÔÚÏߵȴý£¬¼±¼±¼±£¬×îºÃÊÇÏêϸ²½Ö裡
֮ǰÎÒ×öµÄ×÷ÒµÓеãÎÊÌ⣡
°ïUP

²Î¿¼:http://hi.baidu.com/toiota ......

ASP¡£netÖÐÔõôµ÷ÓÃCom+×齨 - .NET¼¼Êõ / ASP.NET

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 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ