ランã‚ングをå–å¾—ã™ã‚‹SQL | Sun Limited Mt.ランã‚ングをå–å¾—ã™ã‚‹SQL ã§ã™ã€‚ åŒã˜ã‚¹ã‚³ã‚¢ã®å ´åˆã¯åŒã˜é †ä½ã«ã™ã‚‹ãªã©ã®å¿…è¦ãŒã‚ã‚‹ãŸã‚çµæ§‹é¢å€’ã§ã™ãŒã€ 下記SQL ã§ã‚¤ãƒƒãƒ‘ツã§å–å¾—ã§ãã¾ã™ã€‚ 実際ã«æºå¸¯ã‚²ãƒ¼ãƒ ã®ãƒ©ãƒ³ã‚ングをå–å¾—ã™ã‚‹ã®ã«ä½¿ç”¨ã—ã¦ã„ã‚‹SQLã§ã™ã€‚ ranking テーブル CREATE TABLE ranking ( id bigint(20) NOT NULL auto_increment, name varchar(20) NOT NULL, score bigint(20) NOT NULL, ); SQL SELECT r1.name, r1.score, (SELECT count(r2.score) FROM ranking as r2 WHERE r2.score>r1.score)+1 as rank FROM ranking as r1 ORDER BY r1.score DESC LIMIT 10; r
{{#tags}}- {{label}}
{{/tags}}