¼±ÇóÒ»¸öSQLÓï¾ä
±í READ
×Ö¶Î £º ID DATE MOUNT
01 1/2/2010 1
01 2/2/2010 2
01 3/2/2010 3
02 1/2/2010 7
02 2/2/2010 8
03 1/2/2010 9
03 2/2/2010 8
ÈçÉÏ£ºÄ¿µÄÊÇ Çóÿ¸öIDµÄdateʱ¼äÀë´«½ø²ÎÊý×î½üµÄÄÇÌõµÄMOUNTµÄºÍ
±ÈÈçÎÒÊäÈë²ÎÊýindateÊÇ3/2/2010 ÄÇÎÒÒªµÄ½á¹û¾ÍÊÇ £¨01 3/2/2010 3£© £¨02 2/2/2010 8£©
(03 2/2/2010 8)
3+8+8=19;
ûÈË»áÂð???
Èç¹ûÒª´«3,Êý¾ÝÀïÓÐ2,4,Äǵ½µ×È¡2»¹ÊÇ4
È¡4 ÆäʵÊDz»ÔÊÐíÊäÖмäÖµµÄ
¾ÍÊǰ´DATEÅÅÐò È¡µÚÒ»Ìõ
with tmp as(
select 1 fid, sysdate-3 as fdate,2 mout from dual
union all
select 1 fid, sysdate-2 fdate,2 mout from dual
union all
select 1 fid, sys
Ïà¹ØÎÊ´ð£º
ÎÒÓжà¸ö±íA B C ½á¹¹ÊÇÒ»ÑùµÄ£¬¶¼ÓÐ2¸ö×Ö¶ÎnameºÍcontent,ÎÒÒªËÑË÷ËùÒÔ±íËùÓÐ×Ö¶ÎÖаüº¬¡°Öйú¡±µÄÄÚÈÝ Õâ¸öSQLÓï¾äÔõôд
ÈçºÎ½«¶à¸ö±íµÄ²éѯ½á¹ûÁ¬³ÉÒ»¸ö±í Õâ¸öSQLÓï¾äÔõôд ±íµÄ½á¹¹ÊÇÒ»ÑùµÄ
ÀýÈç£ ......
select convert(varchar(50),cast(convert(numeric(18,2),1275674000000/100000000)as real))+'ÒÚ'
select cast(convert(numeric(18,2),1275674000000/100000000)as real)
ΪʲôÉÏÒ»¸öÓÃvarcharת»»ºó¾ÍÖ»±£ÁôÁËÒ ......
´ÓÊý¾Ý¿âÖвéѯһÕűíµÄÊý¾Ý
select ²¿ÃÅ,ÐÕÃû from tb
ÈçºÎ²ÅÄÜÉú³ÉÏÂÃæµÄxml¸ñʽ
XML code:
<folder state="unchecked" label="È«²¿">
¡¡¡¡ <folder state="unchecked&qu ......
sqlserver2005 ½¨Á¢µÄÊý¾Ý¿â£¬ÓëÊÖ³Öpda´«ÊäÊý¾Ý£¬×î½üͻȻ³öÏÖÎÞ·¨´«µÝÊý¾ÝµÄÎÊÌ⣬pda¶ËÌáʾµÄ´íÎóʱoutofmemoryexception£¬µ«ÊÇpdaÉÏÃæµÄÈÝÁ¿Ã»ÓÐÎÊÌ⣬
sqlserverµÄÈÕ×ÓÉϵĴíÎóÈçÏ£º
ÈÕÆÚ 2010-1-25 14:45: ......
ÈçºÎÔÚSQL2005ÖÐÉ趨¶¨Ê±×÷Òµ£¬±ÈÈç˵¶¨Ê±ÇåÀíijЩ±íµÄÊý¾Ý£¬
»òÕßÊǶ¨Ê±µÄ½«Ä³Ð©±íµÄÊý¾Ýµ¼³öexcel£¡
ÔÚÏߵȴý£¬¼±¼±¼±£¬×îºÃÊÇÏêϸ²½Ö裡
֮ǰÎÒ×öµÄ×÷ÒµÓеãÎÊÌ⣡
°ïUP
²Î¿¼:http://hi.baidu.com/toiota ......