Çë½Ì¸÷λ´ó¸çÒ»¸ö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°æµÄ£¬»ù±¾Ë¼ÏëÓ¦¸Ã²î²»¶àµÄ¡£¡£ ......
sql table±íÓиöÎı¾ÀàÐ͵Äa×ֶΣ¬´æ´¢µÄÄÚÈÝÈ«²¿ÊÇÊý×Ö£¬ÀýÈç2009001£¬2008578ÕâÑùµÄ¸ñʽ£»b×Ö¶ÎÎı¾ÀàÐÍ£¬´æµÄÒ²ÊÇÊý×ÖÀýÈç 001£¬123
aspÀïÃæ strday=100£¬strb=001
ÎÒÏë¶Á³ö£¬´Óa×ֶεÄÊý×Ö°´´óµ½Ð¡µÄË ......
½«Ò»¸ö±í21~30ɾ³ý£¬sqlÓï¾äÔõôд
Õâ¸öÌ«ÁýͳÁË£¬ÊÇÅÅÐòºóµÄµÚ21Ìõµ½30Ìõ¼Ç¼ɾ³ý»¹ÊÇijһÁÐÖµÔÚ21µ½30Ö®¼äµÄɾ³ý°¡£¿
21-30ÊÇʲôÒâ˼£¿×ֶεϰ¾Ídelete from table1 where col1>=21 and col1<=30
Ö¸µ ......
ÎÒÏÖÔÚÓÐÁ½ÕÅ±í£º
Ò»ÕÅuser±íÓÐname£¨ÐÕÃû£©ºÍstarID£¨ÐÇ×ùµÄID£©Á½¸öÁУ¬»¹ÓÐÒ»ÕÅstars±íÓÐID£¨ÐÇ×ùµÄID£©ºÍstar£¨ÐÇ×ùÃû£©Á½¸öÁУ¬È»ºóstars±íµÄIDÊÇÖ÷¼ü£¬user±íµÄstarIDÊÇÍâ¼ü¡£
ÎÊÌâ¾Í ......
Óбí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 ......