±È½Ï¶þ¸ösqlµÄЧÂÊ - MS-SQL Server / »ù´¡Àà

¿Í»§±í(_CLIENT) ID(±êʶÁÐ) NAME(¿Í»§Ãû³Æ)
¶©µ¥±í (_ORDER) ID(±êʶÁÐ) CLIENTID(¿Í»§±íID) MONEY(¶©µ¥¼Û¸ñ)
 CLIENT ID,NAME
  ORDER ID,CLIENTID,MONEY
SQL code:

_CLIENT ID,NAME
_ORDER ID,CLIENTID,MONEY


SELECT TOP 10 O.CLIENTID,MAX(C.NAME ),SUM(O.MONEY) from _CLIENT C
JOIN _ORDER O ON C.ID=O.CLIENTID
GROUP BY O.CLIENTID

SELECT O.CLIENTID,MAX(C.NAME ),SUM(O.MONEY) from(SELECT TOP 10 ID,NAME from _CLIENT)C
JOIN _ORDER O ON C.ID=O.CLIENTID
GROUP BY O.CLIENTID




2¸ösqlÄĸöЧÂʸß

---

»¹ÓÐ
SQL code:

SELECT TOP 10 O.CLIENTID,MAX(C.NAME ),SUM(O.MONEY) from _CLIENT C
JOIN _ORDER O ON C.ID=O.CLIENTID
GROUP BY O.CLIENTID

»¹ÓÐMAX(C.NAME )
±¾À´Ïë C.NAME µ«ÊDZàÒëÆ÷˵:ÒòΪ¸ÃÁÐûÓаüº¬ÔھۺϺ¯Êý»ò GROUP BY ×Ó¾äÖÐ

MAX(C.NAME ) »á²»»áÓ°ÏìЧÂÊ NAMEºÍid¶¼ÊÇΨһ²»Öظ´µÄ

---

´óÀÐÃÇ,¶¼°ïæ¿´¿´

---

¿´´óϺÃÇÔõô˵µÄ

---

ÒýÓÃ

¿Í»§±í(_CLIENT) ID(±êʶÁÐ) NAME(¿Í»§Ãû³Æ)
¶©µ¥±í (_ORDER) ID(±êʶÁÐ) CLIENTID(¿Í»§±íID) MONEY(¶©µ¥¼Û¸ñ)
CLIENT ID,NAME
ORDER ID,CLIENTID,MONEY

SQL code

_CLIENT ID,NAME
_ORDER ID,CLIENTID,MONEY


SE¡­¡­