SQLÓï¾äÎÊÌâ - MS-SQL Server / ÒÉÄÑÎÊÌâ
Çë½Ì¸ßÊÖ£º
ÒÔÏÂÊÇÊý¾Ý¿âÖеÄÈýÌõ¼Ç¼£¬Ó¢ÎÄΪ×Ö¶ÎÃû³Æ
id planname TaskBeginTime Status
329 2010Äê03Ô·ݼ¼ÊõÖÐÐļƻ®½¨ÒéÊé 2010-3-30 15:43:55 5 329 2010Äê03Ô·ݼ¼ÊõÖÐÐļƻ®½¨ÒéÊé 2010-3-30 16:21:17 5 329 2010Äê03Ô·ݼ¼ÊõÖÐÐļƻ®½¨ÒéÊé 2010-4-3 15:47:17 2
332 2010Äê03Ô·Ýbb¼Æ»®½¨ÒéÊé 2010-3-31 8:44:39 5 332 2010Äê03Ô·Ýbb¼Æ»®½¨ÒéÊé 2010-3-31 10:03:02 2
332 2010Äê03Ô·Ýbb¼Æ»®½¨ÒéÊé 2010-3-31 8:50:02 5
ÏÖÔÚÎÒÏëµÃµ½Ã¿Ò»¸ö¼Æ»®ÖÐTaskBeginTime×î´óµÄ¼Ç¼,ÓÃÒÔÏÂSQLÓï¾ä
SELECT PlanName, MAX(TaskBeginTime) AS Expr1
from planapprstatus
GROUP BY PlanName
Äܹ»µÃµ½329 2010Äê03Ô·ݼ¼ÊõÖÐÐļƻ®½¨ÒéÊé 2010-4-3 15:47:17 2
332 2010Äê03Ô·Ýbb¼Æ»®½¨ÒéÊé 2010-3-31 10:03:02 2
ÕâÁ½Ìõ¼Ç¼£¬
µ«Êǵ±ÎÒÓÃÒÔÏÂÓï¾äʱ(¼ÓÈëStatus)
SELECT PlanName, MAX(TaskBeginTime) AS Expr1,Satus
from planapprstatus
GROUP BY PlanName,Status
È´µÃµ½4Ìõ¼Ç¼
329 2010Äê03Ô·ݼ¼ÊõÖÐÐļƻ®½¨ÒéÊé 2010-3-30 16:21:17 5 329 2010Äê03Ô·ݼ¼ÊõÖÐÐļƻ®½¨ÒéÊé 2010-4-3 15:47:17 2
332 2010Äê03Ô·Ýbb¼Æ»®½¨ÒéÊé 2010-3-31 10:03:02 2
332 2010Äê03Ô·Ýbb¼Æ»®½¨ÒéÊé 2010-3-31 8:50:02 5
Çë¸ßÊÖÖ¸µã£¬Õâ¸öSQLÓï¾äÓÐʲôÎÊÌâ
²»Í¬µÄPlanName,Status¾Í·ÖΪһ×é
so.......
SQL code
{{-
Ïà¹ØÎÊ´ð£º
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
org.apache.jas ......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
½ñÌì×öÁËÒ»¸ö´æ´¢¹ý³Ì »·¾³ÊÇSQL2000Êý¾Ý¿â
´óÖÂÈçÏÂ
½¨Á¢ÁÙʱ±í
¶¨ÒåÔ±¹¤Óαê
Ñ»·Ô±¹¤£¨ÊôÓÚ1¸ö¹«Ë¾)
......
sqlserver2005 ½¨Á¢µÄÊý¾Ý¿â£¬ÓëÊÖ³Öpda´«ÊäÊý¾Ý£¬×î½üͻȻ³öÏÖÎÞ·¨´«µÝÊý¾ÝµÄÎÊÌ⣬pda¶ËÌáʾµÄ´íÎóʱoutofmemoryexception£¬µ«ÊÇpdaÉÏÃæµÄÈÝÁ¿Ã»ÓÐÎÊÌ⣬
sqlserverµÄÈÕ×ÓÉϵĴíÎóÈçÏ£º
ÈÕÆÚ 2010-1-25 14:45: ......
id url rank ......