Çë½Ì·Ö×éͳ¼ÆµÄSQL?
Ö÷±ítbJbxx:nsID,xm,xxmc//nsIDÊÇÖ÷¼ü,xmÐÕÃû,xxmc ѧУÃû³Æ
×Ó±íÒ»tbKmOne:nsID,cjDC,Kssj//cjDc³É¼¨µÈ´Î,Ö»ÓкϸñºÍ²»ºÏ¸ñÁ½ÖÖȡֵ,Kssj¿¼ÊÔʱ¼ä
×Ó±í¶þtbKmTwo:nsID,cjDc,kssj
×Ó±íÈýtbThree:nsID,cjDc,kssj
Çó:
°´xxmc(ѧУÃû³Æ),ÔÚÖ¸¶¨Kssj(¿¼ÊÔʱ¼ä)µÄºÏ¸ñÂÊ.
2010Äê1Ô¸÷ѧУ¿¼ÊԳɼ¨ºÏ¸ñÂÊÅÅÃû:
xxmc KmOne KmTwo KmThree ƽ¾ùºÏ¸ñÂÊ
µÚ¶þÖÐѧ 89% 88% 93% 90%
³ÇЧÖÐѧ .. .. .. 88%
ÊÊ´æÖÐѧ .. .. .. 83%
ƽ¾ùºÏ¸ñÂÊϵָ¸ÃУ×ܺϸñÈËÊý/×ܲο¼ÈËÊý
ϰàÁË£¬°ïÄ㶥һϡ£
3±íunion all ÐÐתÁÐ
ÄÜÓÃÒ»ÌõSQLÓï¾äд³öÀ´Âð?
²Î¿¼
SQL code:
/*
±êÌ⣺ÆÕͨÐÐÁÐת»»(version 2.0)
×÷Õߣº°®Ð¾õÂÞ.ع»ª(Ê®°ËÄê·çÓê,ÊØµÃ±ùɽѩÁ«»¨¿ª)
ʱ¼ä£º2008-03-09
µØµã£º¹ã¶«ÉîÛÚ
˵Ã÷£ºÆÕͨÐÐÁÐת»»(version 1.0)½öÕë¶Ôsql server 2000Ìṩ¾²Ì¬ºÍ¶¯Ì¬Ð´·¨£¬version 2.0Ôö¼Ósql server 2005µÄÓйØÐ´·¨¡£
ÎÊÌ⣺¼ÙÉèÓÐÕÅѧÉú³É¼¨±í(tb)ÈçÏÂ:
ÐÕÃû ¿Î³Ì ·ÖÊý
ÕÅÈý ÓïÎÄ 74
ÕÅÈý Êýѧ 83
ÕÅÈý ÎïÀí 93
ÀîËÄ ÓïÎÄ 74
ÀîËÄ Êýѧ 84
ÀîËÄ ÎïÀí 94
Ïë±ä³É(µÃµ½ÈçϽá¹û)£º
ÐÕÃû ÓïÎÄ Êýѧ ÎïÀí
---
Ïà¹ØÎÊ´ð£º
ÎÒÓжà¸ö±í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 ......
³¡¾°ÈçÏ£º
¿Í»§°Ñ±¸·ÝºÃµÄÊý¾Ý¿â£¬·¢¸øÎÒ£¬ÎÒÔÚ±¾»ú»¹Ôºó£¬ÔËÐÐдºÃµÄ´æ´¢¹ý³Ì£¬±È½Ï¿ì£¬²¢ÇÒÔÚʵʩÄDZßÔËÐÐͬÑù±È½Ï¿ì¡£µ«Êǵ±ÊµÊ©ÔÚ¿Í»§ÄDZßÔËÐеÄʱºòËٶȾͷdz£µÄÂý£¬Ê±¼ä³¬³öÁ˳ÌÐòµÄʱ¼äÏÞÖÆ¡£Ô¶³ÌÔÚ¿Í»§ÄÇ ......
tab1 ×Ö¶Î:billdate,goodsid,incount,inmoney,outcount,outmoney,endprice,endcount,endamt
tab2 ×Ö¶Î:goodsid,goodskind£¨ÉÌÆ·ÀàÐÍ£©
tab3 ×Ö¶Î:goodskind£¨ÉÌÆ·ÀàÐÍ£©,kindname
½á¹û£º
µÃµ½ÉÌÆ·ÀàÐÍÔÚÒ»¶Îʱ¼ä ......
×Ö¶Î1,×Ö¶Î2.....×Ö¶ÎN,Status,ParentID
1,Name1....test1,1,99
1,Name1....test1,3,99
1,Name2....test2,1,101
1,Name2....test2,3,101
1,Name3....test3,2,101
1,Name1....test1,4,101
ÏëÒªµÄ½á¹ûÊÇ:
1,Na ......