Çë½Ì¸÷λ´ó¸çÒ»¸öSqlÎÊÌ⣬Äĸö°à¼¶µÄ½Ìʦ´ýÓö×î¸ß£¿
СµÜ×î½üÓöµ½Ò»¸öÎÊÌ⣬ҪÇóµÃ³öÄĸö°à¼¶µÄ½Ìʦ´ýÓö×î¸ß£¬°Ñͬһ¸ö°à¼¶µÄ½Ìʦ´ýÓöºÏ¼ÆÆðÀ´
°à¼¶±í ½Ìʦ±í
°à¼¶ID ½ÌʦID
°à¼¶Ãû×Ö °à¼¶ID
½Ìʦ´ýÓö
Ê×ÏÈÏëµ½µÄÊÇÓÃMAX£¨´ýÓö£©,µ«ÊÇÖ»Äܵóö´ýÓö×î¸ßµÄ½Ìʦ£¬ºóÏëһϣ¬ºÃÏñÖ»Óд洢¹ý³Ì²ÅÄÜ´¦Àí£¬¶øÇÒ´æ´¢¹ý³ÌÖл¹ÒªÑ»·´¦Àí°à¼¶ÊýºÍ½ÌʦÊý£¬±È½ÏÂé·³¡£
×îºóÒªÇó°´ÕÕ´ýÓö×î¸ßµÄ°à¼¶ÅÅÐòÏÂÀ´¡£
²»ÖªµÀ¸÷λ´ó¸çÓÐûÓкõÄ˼·ºÍ·½·¨£¬×îºÃµÄÊÇÒ»¾äSql¾ÍÄÜÍê³ÉµÄ¡£ÈçÓдúÂë¸üºÃ£¬Ð»Ð»ÁË
select °à¼¶ID,sum(½Ìʦ´ýÓö)
from ½Ìʦ±í
group by °à¼¶ID
order by 2 desc
SQL code:
select °à¼¶Ãû×Ö,sum(½Ìʦ´ýÓö)
from ½Ìʦ±í ,°à¼¶±í
where ½Ìʦ±í.°à¼¶ID = °à¼¶±í.°à¼¶ID
group by °à¼¶Ãû×Ö
order by 2 desc
SQL code:
select m.* , avg(n.½Ìʦ´ýÓö) ½Ìʦ´ýÓö from °à¼¶±í m , ½Ìʦ±í n where m.°à¼¶ID = n.°à¼¶ID group by m.°à¼¶ID,°à¼¶Ãû×Ö order by ½Ìʦ´ýÓö desc
ÊÇÓÃavg°É?ƽ¾ù´ýÓö°É?
²»ÊÇÓÃsum.
SQL code
{
Ïà¹ØÎÊ´ð£º
±¾ÈËc#ÐÂÊÖ ¿ÉÊÇÒªÇóÒªÓÃc# £¬sql2000¿ª·¢c/sµÄ¹¤×÷Á÷£¬Ò»Í·ÎíË®£¬Çë´ó¼Ò°ïæ°ï棬¸øµã˼·£¬ËµµÄÔ¼¾ßÌåÔ½ºÃ£¬ÎÒÒ²ºÃÍùÄǸö·½ÃæÈ¥Ñ§Ï°
http://www.hxzi.com/view/61402.html
B/S°æµÄ£¬»ù±¾Ë¼ÏëÓ¦¸Ã²î²»¶àµÄ¡£¡£ ......
....½Óµ½Ò»¸öС³ÌÐò..¹¤×÷ÔÀ´´ó¸ÅÊÇÕâÑùµÄ...ǰ̨ÊÇWEB·þÎñÆ÷.¼Ü¹¹¾ÍÊÇASP+SQL..ǰ̨ÓÉASPÏòSQLÌí¼Ó·þÎñÀà±ð(±íµ¥).È»ºóÓÖºǫ́³ÌÐò¶ÁÈ¡±íµ¥..Ҫʵʱ¶ÁÈ¡..È»ºóÏÔʾÔÚ·þÎñÆ÷ÉÏÃæ..´ÓÀíÂÛÉÏÃæÄÜÐÐͨ²»?Èç¹û¿ÉÒÔ..ºǫ́ ......
ÎÒÓÐÒ»¸öÔºÍÈÕ×é³ÉµÄÊý×Ö£¬ÓÐÁ½×éÔºÍÈÕ
ÏëÔÚÉí·ÝÖ¤ºÅÖÐÌôÑ¡³öÔڸøÃÁ½×éÔÂÈÕÖ®¼ä³öÉúµÄÈË£¬²»ÖªµÀÓ¦¸ÃÔõôд.
Éí·ÝÖ¤ºÅÓпÉÄÜÊÇ15λ»òÕß18λ
ÔÂÈÕ×éºÏµÄÐÎʽÈçÏÂ
10-17/04-20
ÔÂ-ÈÕ/ÔÂ- ......
ÔÚÏȰ²×°ÁËvs.net 2008 ºóÔõô°²×° Sql server 2005¡£ËÑÁ˺ܶàÎÄÕ£¬¿ÉÊÇ»¹ÊÇûÓп´µ½Ôõô²ÅÄܹ»°²×°ÉÏ¡£
×ÜÊÇÔÚ°²×°sql serverµÄ¿Í»§¶Ë£¨management studio£©Ê±ºò±¨´í£¬×°ÄǸöÊý¾Ý¿â server ÒýÇæµÄʱºòûÓÐÎ ......
ÓбíA£¬ÈçÏ£º
x y name ID sxm
300 500 a 1
301 501 b 2
302 502 c 3
303 503 d 4
304 504 a 5
305 505 b 6
306 506 c 7
307 507 d 8
308 508 a 9
309 509 b 10
310 ......