Znn3bq.jpeg
²é¿´: 841  |  »Ø¸´: 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 µÄÖ÷Ìâ¸üÐÂ
×î¾ßÈËÆøÈÈÌûÍÆ¼ö [²é¿´È«²¿] ×÷Õß »Ø/¿´ ×îºó·¢±í
[¿¼ÑÐ] Ò»Ö¾Ô¸»ªÖÐũҵ071010£¬320Çóµ÷¼Á +14 À§À§À§À§À¤À¤ 2026-04-14 16/800 2026-04-16 22:02 by Öí»á·É
[¿¼ÑÐ] 304Çóµ÷¼Á +5 castLight 2026-04-16 5/250 2026-04-16 21:49 by ѧԱJpLReM
[¿¼ÑÐ] 0854Çóµ÷¼Á +21 ÃÅ·ÃþÃþ 2026-04-15 24/1200 2026-04-16 21:24 by Art1977
[¿¼ÑÐ] Ò»Ö¾Ô¸»¦9£¬ÉúÎïѧ326Çóµ÷¼Á +9 Áõīī 2026-04-15 9/450 2026-04-16 17:14 by ´Þ´Þ´Þcccc
[¿¼ÑÐ] 271Çóµ÷¼Á +35 2261744733 2026-04-11 37/1850 2026-04-16 13:16 by jiahl2024
[¿¼ÑÐ] ³õÊÔ324 ÖÐҩѧ Ò»Ö¾Ô¸ÌìÖÐÒ½ Çóµ÷¼Á +4 ÀîµÄLucky 2026-04-10 4/200 2026-04-16 09:22 by fqwang
[¿¼ÑÐ] ÉúÎïѧµ÷¼Á +9 Ö½ÉÈzhishan 2026-04-13 9/450 2026-04-15 18:28 by ANÁ÷800
[¿¼ÑÐ] ¸÷λÀÏʦºÃ£¬Çóµ÷¼Á£¬±¾¿Æ211£¬Ò»Ö¾Ô¸Ìì½ò´óѧÉúÎïÓëҽҩѧ˶£¬²îÁ½Ãû¼ȡ¡£ +11 ·ÁùÁùjjj 2026-04-13 11/550 2026-04-14 16:01 by zs92450
[¿¼ÑÐ] ҩѧ305Çóµ÷¼Á +10 Â꿨°Í¿¨boom 2026-04-10 10/500 2026-04-14 15:55 by zs92450
[¿¼ÑÐ] ũѧ0904 312Çóµ÷¼Á +4 Say Never 2026-04-11 4/200 2026-04-14 09:10 by zs92450
[¿¼ÑÐ] »úе»¹Óл¹ÓÐÃû¶îÂð£¿Ì«ÄÑÁË +8 ЦЦԬ 2026-04-10 8/400 2026-04-14 08:44 by screening
[¿¼ÑÐ] Çóµ÷¼Á +3 ÎÒ°®¸ßÊý¸ßÊý°®Î 2026-04-12 3/150 2026-04-14 01:00 by Íõ¬Bè±
[¿¼ÑÐ] 332Çóµ÷¼Á +15 ½¶½¶123 2026-04-10 15/750 2026-04-13 23:12 by pies112
[¿¼ÑÐ] Çóµ÷¼Á£¬985²ÄÁÏÓ뻯¹¤348·Ö +9 º­ÖñÁõ 2026-04-11 14/700 2026-04-13 22:26 by º­ÖñÁõ
[¿¼ÑÐ] ²ÄÁÏ¿¼Ñе÷¼Á +29 ÔÆÄ¾´ï´ï 2026-04-11 31/1550 2026-04-13 13:32 by lyh³ÀÏʦ
[¿¼ÑÐ] 0831Ò»ÂÖµ÷¼Áʧ°ÜÇóÖú +10 СÐÜî£î£_s 2026-04-11 10/500 2026-04-12 22:43 by ³¤¹­°Á
[¿¼ÑÐ] µçÆø×¨Ë¶320Çóµ÷¼Á +6 СÂé×Ó111 2026-04-10 6/300 2026-04-12 10:54 by lemon6009
[¿¼ÑÐ] 296Çóµ÷¼Á +14 Íô£¡£¿£¡ 2026-04-10 16/800 2026-04-12 10:48 by zhouyuwinner
[¿¼ÑÐ] Çóµ÷¼Á£¬Ò»Ö¾Ô¸´óÁ¬Àí¹¤´óѧ354·Ö +5 ÓêÉùÓàÉú 2026-04-11 6/300 2026-04-11 16:12 by ÓêÉùÓàÉú
[¿¼ÑÐ] ũѧ0904 312Çóµ÷¼Á +6 Say Never 2026-04-10 6/300 2026-04-11 10:33 by wwj2530616
ÐÅÏ¢Ìáʾ
ÇëÌî´¦ÀíÒâ¼û