POSTGRESQLã®SQLã§ä»¥ä¸ã¯ã©ã®ããã«æ¸ãã®ã§ããããï¼ PHPã§ããã¾ãã PHPã§ã®å¤æ°ãå¹´ã$yearãæã$monthã¨ãã¾ãã ãã¼ãã«Aã¯æ¬¡ã®ããã«ãªã£ã¦ãã¾ãã(ins_dateã¯dateå) no price ins_date 1 5000 2006-03-01 2 4000 2005-10-10 3 3000 2006-01-11 4 2000 2006-02-15 5 1000 2005-12-24 6 2000 2006-02-24 ããããã (1)$yearå¹´$monthæãå«ãã§ããããããåã®æéã®selectçµæ ï¼ä¾ãã°2005å¹´12æã ã¨ãããã2005å¹´12æã¾ã§ã®çµæãnoã§è¨ãã¨ã2ã¨5ãçµæã¨ãã¦ã§ããããªSQLï¼ (2)$yearå¹´$monthæã®çµæ ï¼ä¾ãã°2006å¹´02æã ã¨ãããã2006å¹´02æã¾ã§ã®çµæãnoã§è¨ãã¨ã4ã¨6


{{#tags}}- {{label}}
{{/tags}}