æ¥å¥ã®éè¨ãã¼ã¿ãåã SQL ã®ä½æãè¡ããã¨ã«ãªã£ãã®ã§ããããã¼ã¿ã®ç¨®å¥æ¯ã« SQL ãçºè¡ããã¨ã¬ã¹ãã³ã¹çã«ãã¾ããããªã¨æããä¸ã¤ã®ã¯ã¨ãªã§ä½ã¨ãåå¾åºãããã«ãã¦ã¿ã¾ããã ãã¨ãã°ä¸è¨ã®ãããªãã¼ãã«ãããã¨ãã¾ãã Sales ãã¼ãã«(主ãã¼(CustomerID,LineNo)ã¨éè¨ã«å¿ è¦ãªå以å¤ã¯çç¥) ââââââââââââââââââââââââââ âCustomerID LineNo SalesDate Quantity Money â â22 4 20090301 1 105 â â22 1 20090302 2 2520 â â21 1 20090302 5 10050 â â22 2 20090310 1 1050 â â22 3 20090310 1 1260 â â23 1 20090310 1 14700 â â16 1 20090310 1
{{#tags}}- {{label}}
{{/tags}}