MySQL :: MySQL 8.0 リファレンスマニュアル :: 3.6.4 特定ã®ã‚«ãƒ©ãƒ ã®ã‚°ãƒ«ãƒ¼ãƒ—ã”ã¨ã®æœ€å¤§å€¤ãŒæ ¼ç´ã•ã‚Œã¦ã„る行タスク: 物å“ã”ã¨ã«æœ€é«˜å€¤ã‚’付ã‘ã¦ã„ã‚‹æ¥è€… (複数å¯) を調ã¹ã¾ã™ã€‚ ã“ã®å•é¡Œã¯ã€æ¬¡ã®ã‚ˆã†ãªã‚µãƒ–クエリーを使用ã—ã¦è§£æ±ºã§ãã¾ã™ã€‚ SELECT article, dealer, price FROM shop s1 WHERE price=(SELECT MAX(s2.price) FROM shop s2 WHERE s1.article = s2.article) ORDER BY article; +---------+--------+-------+ | article | dealer | price | +---------+--------+-------+ | 0001 | B | 3.99 | | 0002 | A | 10.99 | | 0003 | C | 1.69 | | 0004 | D | 19.95 | +---------+--------+-------
{{#tags}}- {{label}}
{{/tags}}