SQL Óï¾ä
Ò»¸ö ͳ¼Æ±í£¬ Àà±ð ½ð¶î ÈÕÆÚ Ê±¼ä·¶Î§ A 100 2010-1-2 2010-1-2 B 10 2010-1-3 2010-1-3 A 50 2010-1-4 2010-1-4 C 20 2010-1-5 2010-1-5 ÎÒÒª¸ù¾Ýʱ¼ä·¶Î§ ²éѯ ijÀà µÄ ×ܽð¶î ºÍÈÕÆÚÔõôд£¿ select ÈÕÆÚ£¬Àà±ð£¬sum(½ð¶î) from ͳ¼Æ where ÈÕÆÚ·¶Î§ group by Àà±ð Õâ¾ä´íÎó ÌáʾΪ ÈÕÆÚÔÚÑ¡ÔñÁбíÖÐÎÞЧ£¬ÒòΪ¸ÃÁмȲ»°üº¬ÔÚ ¾ÛºÏº¯ÊýÖУ¬Ò²²»°üº¬ÔÚ group by ×ÓÓï¾äÖÐ
select ÈÕÆÚ£¬Àà±ð£¬sum(½ð¶î) from ͳ¼Æ where ÈÕÆÚ·¶Î§ group by Àà±ð£¬ÈÕÆÚ select ÈÕÆÚ£¬Àà±ð£¬sum(½ð¶î) as ½ð¶î from ͳ¼Æ where ÈÕÆÚ·¶Î§ group by ÈÕÆÚ,Àà±ðÒýÓà select ÈÕÆÚ£¬Àà±ð£¬sum(½ð¶î) as ½ð¶î from ͳ¼Æ where ÈÕÆÚ·¶Î§ group by ÈÕÆÚ,Àà±ð Àà±ðµÄ½ð¶îͳ¼ÆÊ§Ð§¡£¡£ ½á¹û¼¯ÎªÒ»ÌõÌõµÄ¼Ç¼£¬Ã»Æðµ½·Ö×éͳ¼ÆµÄЧ¹ûÒýÓà select Àà±ð£¬sum(½ð¶î) as ½ð¶î from ͳ¼Æ where ÈÕÆÚ·¶Î§ group by Àà±ð Õý½â£¬2Â¥µÄ²é·¨Êǰ´Ê±¼äºÍÀà±ð·Ö×飬µ±È»ÊÇÒ»ÌõÒ»ÌõµÄÁË¡£ ÔÚÄãµÄÉÏÒ»ÌùÀïÃæ¾Íд¸øÄãÁË.¿´µãSQLÓï·¨°É... ¡¾ÎÒÒª
Ïà¹ØÎÊ´ð£º
Ö´ÐеÄ˳Ðò£º 1£©Îļþä¯ÀÀ¿ò£¨Ñ¡ÔñÎļþʹÓã© Ñ¡ÔñºÃÎļþºó µã»÷Ò»¸öµ¼Èë°´Å¥µÄʱºò £¬°ÑÉÏÃæÉÏ´«¿òÀïµÄcsvÎļþÒÔÒ»¸öIDΪÎļþÃû£¬ÉÏ´«µ½**/**Îļþ¼ÐÏ 2£©¶ÁÈ¡Õâ¸öÎļþ¼ÐϵÄcsvµÄÎļþ£¬×ª»»³Ésql 3 ......
ÎÒÓжà¸ö±íA B C ½á¹¹ÊÇÒ»ÑùµÄ£¬¶¼ÓÐ2¸ö×Ö¶ÎnameºÍcontent,ÎÒÒªËÑË÷ËùÒÔ±íËùÓÐ×Ö¶ÎÖаüº¬¡°Öйú¡±µÄÄÚÈÝ Õâ¸öSQLÓï¾äÔõôд ÈçºÎ½«¶à¸ö±íµÄ²éѯ½á¹ûÁ¬³ÉÒ»¸ö±í Õâ¸öSQLÓï¾äÔõôд ±íµÄ½á¹¹ÊÇÒ»ÑùµÄ ÀýÈç£ ......
type Exception report message description The server encountered an internal error () that prevented it from fulfilling this request. exception org.apache.jas ......
ÎÒÃÇC#×öÒ»¸ö´°Ìå ÍùÊý¾Ý¿âÀï²åÈëÊý¾Ý SqlConnection cn = new SqlConnection("Data Source=20090713-1752\\SQLEXPRESS;Initial Catalog=goods;Integrated Security=True"); ......
ÏÖÔÚÓÐÁ½ÕÅ±í£ºÎÄÕÂÖ÷±íA(articleId,articleTitle)£¬ÎÄÕÂÆÀÂÛ±íB(commentId,articleId,commentTitle) ÏÖÔÚÎÒÏëʵÏÖÕâÑùµÄ¹¦ÄÜ£ºÁгöÎÄÕÂÁÐ±í£¬ÆäÖÐÿƪÎÄÕ±êÌâÏÂÃæÁгö´ËÎÄÕµÄǰ2¸öÎÄÕÂÆÀÂÛ£¬ÇëÎÊsqlÓï¾äÔõôд°¡ ......