Znn3bq.jpeg
²é¿´: 842  |  »Ø¸´: 3
µ±Ç°Ö»ÏÔʾÂú×ãÖ¸¶¨Ìõ¼þµÄ»ØÌû£¬µã»÷ÕâÀï²é¿´±¾»°ÌâµÄËùÓлØÌû

peachpeachqr

гæ (³õÈëÎÄ̳)

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

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


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

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

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

» ²ÂÄãϲ»¶

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

ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢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µÄ»ØÌû
²é¿´È«²¿ 4 ¸ö»Ø´ð

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µÄ»ØÌû
×î¾ßÈËÆøÈÈÌûÍÆ¼ö [²é¿´È«²¿] ×÷Õß »Ø/¿´ ×îºó·¢±í
[¿¼ÑÐ] 22ר˶Çóµ÷¼Á +10 haoyunÉϰ¶ 2026-04-11 12/600 2026-04-16 22:21 by Öí»á·É
[¿¼ÑÐ] Çóµ÷¼Á +8 СÄô°®Ñ§Ï° 2026-04-16 10/500 2026-04-16 22:06 by 1shin_ichi
[¿¼ÑÐ] 279ѧ˶ʳƷרҵÇóµ÷¼ÁԺУ 20+7 ¹Â¶ÀµÄÀǰ®³ÔÑò 2026-04-12 29/1450 2026-04-16 09:00 by screening
[¿¼ÑÐ] ÇóÖúµ÷¼Á£¬¿çµ÷ +19 XÊ®¸¦´çY 2026-04-11 20/1000 2026-04-15 21:18 by cuisz
[¿¼ÑÐ] 310Çóµ÷¼Á +16 666ÕæºÃ 2026-04-11 18/900 2026-04-15 13:28 by ºÚ¿Æ¼¼¿óÒµ
[¿¼ÑÐ] ²ÄÁÏרҵ344Çóµ÷¼Á +17 hualkop 2026-04-10 22/1100 2026-04-14 16:21 by sxdj2
[¿¼ÑÐ] 366Çóµ÷¼Á +11 ²»ÖªÃûµÄСئ 2026-04-11 11/550 2026-04-14 15:50 by zs92450
[¿¼ÑÐ] ¿¼ÑÐÇóµ÷¼Á +12 ×ÓľÄÅ 2026-04-12 13/650 2026-04-14 01:19 by Íõ¬Bè±
[¿¼ÑÐ] Çóµ÷¼Á +3 ÎÒ°®¸ßÊý¸ßÊý°®Î 2026-04-12 3/150 2026-04-14 01:00 by Íõ¬Bè±
[¿¼ÑÐ] Çóµ÷¼Á +12 Á§ÜÔÒ»¶¨Éϰ¶ 2026-04-10 13/650 2026-04-14 00:08 by Equinoxhua
[¿¼ÑÐ] 344 ²ÄÁÏרҵ Çóµ÷¼Á211 ÎÞµØÓòÒªÇó +8 hualkop 2026-04-11 8/400 2026-04-12 22:24 by fqwang
[½Ìʦ֮¼Ò] ɽ¶«Ë«·ÇԺУ¿¼ºË³¬¼¶ÎÞµ×Ïߣ¬Áìµ¼ÐÒÔÖÀÖ»ö£¬½ÌʦÔâÑê¿Ö +3 qut2026 2026-04-11 7/350 2026-04-12 20:24 by qut2026
[¿¼ÑÐ] µ÷¼Á +5 ÎĵÀÐÇ̨ 2026-04-11 5/250 2026-04-11 15:01 by ¿­¿­Òª±ä˧
[¿¼ÑÐ] Çóµ÷¼Á +3 θ¾·ÂÎÀÛÁË 2026-04-11 5/250 2026-04-11 14:13 by luhong1990
[¿¼ÑÐ] 0859£¬337Çóµ÷¼Á +4 ÑÐs. 2026-04-10 4/200 2026-04-11 11:34 by caotw2020
[¿¼ÑÐ] 284Çóµ÷¼Á +12 archer.. 2026-04-10 13/650 2026-04-11 08:44 by zhq0425
[¿¼ÑÐ] 263ÄÜÔ´¶¯Á¦×¨Ë¶Çóµ÷¼Á +4 ¼Ó´óºÅ·¹ºÐ´ü 2026-04-10 4/200 2026-04-10 20:52 by gong120082
[¿¼ÑÐ] ±¾9 Ò»Ö¾Ô¸Î÷¹¤´ó085601 324Çóµ÷¼Á +5 wysyjs25 2026-04-10 5/250 2026-04-10 16:57 by luoyongfeng
[¿¼ÑÐ] 301Çóµ÷¼Á +5 149. 2026-04-10 5/250 2026-04-10 15:45 by ²ñС°×
[¿¼ÑÐ] 282£¬µçÆø¹¤³Ìרҵ£¬Çóµ÷¼Á£¬²»Ìôרҵ +9 jggshjkkm 2026-04-10 9/450 2026-04-10 14:55 by ÄæË®³Ë·ç
ÐÅÏ¢Ìáʾ
ÇëÌî´¦ÀíÒâ¼û