æè¿ãSQL 㧠WHERE å¥ã«å ¥ãããORDER BY ãã GROUP BY ãããããã㤠MAX() ã ã¨ã MIN() ã ã¨ããæ±ããããå¿ è¦ããªããè¨ããªãã°ãåãã«è¶³ããªãå¤ãã¨ãããåå¥ã®ã«ã©ã ã«æãããããããã®ãä¸æ°ã«ã¾ã¨ã㦠text åã®ã«ã©ã ã«å ¥ããããããã¨ããã£ããããã ä¾ãã°ãä½æé²ãä½ãããªãã¤ã£ã¦ããã¼ãã«ãçµã¿ããããã ãããããã WHERE å¥ã«å ¥ãè¦ç´ ãªãã¦ååããããããªããªãâ¦ã¨ããå ´å㯠CREATE table address ( id int unsigned NOT NULL auto_increment, name varchar(255) NOT NULL default '', props text, PRIMARY KEY (id), KEY (name) ); ãããªãããªãã¼ãã«ãä¸åä½ã£ã¦ãããããã¦ã è¦ããã«ãn
{{#tags}}- {{label}}
{{/tags}}