Znn3bq.jpeg
ÉÇÍ·´óѧº£Ñó¿ÆÑ§½ÓÊܵ÷¼Á
²é¿´: 840  |  »Ø¸´: 3

peachpeachqr

гæ (³õÈëÎÄ̳)

[ÇóÖú] ÏëÇë½ÌÒ»¸öSQLµÄÎÊÌ⣬ÓÐÀÍ´ïÈËÃǰïæ¿´Ò»ÏÂ~СŮ×Ó²»Ê¤¸Ð¼¤~¾Ï¹ª

ÎÊÌâÊÇÕâÑùµÄ


ÎÒÒªÕâЩÊý¾Ý°´ÕÕJHÁзÖ×飬ͬʱÏÔʾrqÖÐ×îеÄÁ½ÐÐÊý¾Ý£¬ÔÙ½øÐÐCZÕâÁеÄÏà¼Ó

ÏëÇë½ÌÏÂSQLµÄÓï¾äÓ¦¸ÃÔõôд

·Ç³£¸Ðл~~
»Ø¸´´ËÂ¥

» ²ÂÄãϲ»¶

» ±¾Ö÷ÌâÏà¹Ø¼ÛÖµÌùÍÆ¼ö£¬¶ÔÄúͬÑùÓаïÖú:

ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

lurencyj

ľ³æ (ÖøÃûдÊÖ)

¡¾´ð°¸¡¿Ó¦Öú»ØÌû

¡ï
¸Ðл²ÎÓ룬ӦÖúÖ¸Êý +1
jjdg(½ð±Ò+1): ¸Ðл²ÎÓë 2012-03-02 03:03:28
ÊÔÊÔ£º
CODE:
Select rq , sum(CZ) from zsfq1 Group by JH Order   By   yourfield   desc Limited 2;

ºÜÅ®×Ӻܹ­Ëä´ó
2Â¥2012-03-02 00:32:08
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

nebulaly

ľ³æ (ÖøÃûдÊÖ)

¡ï
jjdg(½ð±Ò+1): ¸Ðл²ÎÓë 2012-03-03 02:28:02
¡°Í¬Ê±ÏÔʾrqÖÐ×îеÄÁ½ÐÐÊý¾Ý¡±

Õâ¸öÒªÇó²»Ì«ÄÜ¿´¶®
3Â¥2012-03-03 00:08:25
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

wpacer

Ìú³æ (ÕýʽдÊÖ)

¡¾´ð°¸¡¿Ó¦Öú»ØÌû

Select rq , sum(CZ) from zsfq1 Group by JH Order   By   rq desc  Limited 2;
ÀÊÔ²è¹Ý¶­Ê¹ݳ¤
4Â¥2012-07-26 10:01:50
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû
Ïà¹Ø°æ¿éÌø×ª ÎÒÒª¶©ÔÄÂ¥Ö÷ peachpeachqr µÄÖ÷Ìâ¸üÐÂ
×î¾ßÈËÆøÈÈÌûÍÆ¼ö [²é¿´È«²¿] ×÷Õß »Ø/¿´ ×îºó·¢±í
[¿¼ÑÐ] 290µ÷¼ÁÉúÎï0860 +35 ÍÛ¹þ¹þ£¬¡£ 2026-04-11 41/2050 2026-04-14 23:47 by Xurambo2014
[¿¼ÑÐ] ²ÄÁÏÀà284µ÷¼Á +41 Ïë»»ÊÖ»ú²»Ïë½âÊ 2026-04-08 49/2450 2026-04-14 17:53 by lhj2009
[¿¼ÑÐ] 335Çóµ÷¼Á +19 ÏëÉϰ¶Ñ½£¡£¡ 2026-04-12 21/1050 2026-04-14 16:23 by Art1977
[¿¼ÑÐ] 279ѧ˶ʳƷרҵÇóµ÷¼ÁԺУ 20+6 ¹Â¶ÀµÄÀǰ®³ÔÑò 2026-04-12 28/1400 2026-04-14 15:44 by zs92450
[¿¼ÑÐ] 071000ÉúÎïѧµ÷¼ÁÇóÖú +18 zzzzwww 2026-04-09 21/1050 2026-04-14 15:39 by zs92450
[¿¼ÑÐ] ²ÄÁϸ´ÊÔÇóµ÷¼Á +24 xhhdjdjsjks 2026-04-09 24/1200 2026-04-13 15:49 by ÐÒÃâ ..
[¿¼ÑÐ] 322Çóµ÷¼Á£¬08¹¤¿Æ +4 ½ñÌìÊǸöСºÅ 2026-04-08 4/200 2026-04-13 00:20 by baobaoye
[¿¼ÑÐ] 293Çóµ÷¼Á +6 ÓÂÔ¶¿â°®314 2026-04-08 6/300 2026-04-11 10:08 by zhq0425
[¿¼ÑÐ] ¹ã¶«Ê¡ 085601 329·ÖÇóµ÷¼Á +14 Eddieddd 2026-04-10 14/700 2026-04-11 09:58 by bljnqdcc
[¿¼ÑÐ] 284Çóµ÷¼Á +12 archer.. 2026-04-10 13/650 2026-04-11 08:44 by zhq0425
[¿¼ÑÐ] ±¾¿Æ211 ¹¤¿Æ085400 280·ÖÇóµ÷¼Á ¿É¿çרҵ +11 LZH£¨µÈ´ýµ÷¼ÁÖÐ 2026-04-10 11/550 2026-04-11 08:39 by zhq0425
[¿¼ÑÐ] »¯Ñ§¹¤³ÌÓë¼¼Êõ324µ÷¼Á +23 Ëï³£»ª 2026-04-09 25/1250 2026-04-11 00:07 by ÆïÅ£¶Éº®½­
[¿¼ÑÐ] Ò»Ö¾Ô¸¿ó´ó£¬²ÄÁϹ¤³Ìר˶314·Ö£¬0856¿Éµ÷¶¼¿ÉÒÔ +15 ÎÞи¿É»÷µÄ¾ÞÈË 2026-04-09 15/750 2026-04-10 18:10 by hmn_wj
[¿¼ÑÐ] ³õÊÔ261 +3 AshtÉÙ 2026-04-10 6/300 2026-04-10 16:38 by AshtÉÙ
[¿¼ÑÐ] 298Çóµ÷¼Á +13 ¶¤¶£ß˶¬¹Ï 2026-04-09 13/650 2026-04-10 15:49 by jiajinhpu
[¿¼ÑÐ] Çóµ÷¼Á ²ÄÁÏÓ빤³Ì 324·Ö ר˶ +19 ôæôæÒ»ÊéÉú 2026-04-10 21/1050 2026-04-10 11:41 by wp06
[¿¼ÑÐ] Çൺ¿Æ¼¼´óѧ²ÄÁÏѧԺ£¬»·¾³Ñ§Ôºµ÷¼Á²¹Â¼4ÔÂ10ÈÕÒÔǰ¶¼¿ÉÒÔ +3 1Çà¿Æ´ó¡£ 2026-04-09 5/250 2026-04-10 09:58 by ôæôæÒ»ÊéÉú
[¿¼²©] ²©Ê¿×Ô¼ö +7 ¿É¿ÉСÅÖ 2026-04-08 7/350 2026-04-10 08:28 by kimhero
[ÂÛÎÄͶ¸å] ÇóÖúÎÄÏ×Ô­ÎÄ 10+3 18500821399 2026-04-08 3/150 2026-04-09 16:56 by ±±¾©À³ÒðÈóÉ«
[¿¼ÑÐ] 086004 Çóµ÷¼Á 309 +7 Yin DY 2026-04-08 7/350 2026-04-09 13:59 by Delta2012
ÐÅÏ¢Ìáʾ
ÇëÌî´¦ÀíÒâ¼û