MySQL\u3067\u6307\u5b9a\u3057\u305f\u30ab\u30e9\u30e0\u306e\u6700\u983b\u5024(\u5168\u30c7\u30fc\u30bf\u306e\u4e2d\u3067\u6700\u3082\u591a\u304f\u51fa\u73fe\u3059\u308b\u5024)\u3092\u62bd\u51fa\u3057\u305f\u3044\u3068\u3044\u3046\u30b1\u30fc\u30b9\u304c\u3042\u3063\u305f\u3002\u3056\u3063\u3068\u8abf\u3079\u305f\u3068\u3053\u308d\u6700\u983b\u5024\u3092\u6c42\u3081\u308b\u95a2\u6570\u3068\u3044\u3046\u306e\u306f\u898b\u53d7\u3051\u3089\u308c\u306a\u304b\u3063\u305f\u305f\u3081SQL\u6587\u3067\u4f55\u3068\u304b\u3057\u306a\u3044\u3068\u3044\u3051\u306a\u3044\u3063\u307d\u3044\u3002\u4ee5\u4e0b\u306b\u5bfe\u5fdc\u65b9\u6cd5\u3092\u30e1\u30e2\u3002<\/p>\n
<\/p>\n
mysql> SHOW COLUMNS FROM `test_table`;\r\n+-------+------+------+-----+---------+----------------+\r\n| Field | Type | Null | Key | Default | Extra |\r\n+-------+------+------+-----+---------+----------------+\r\n| id | int | NO | PRI | NULL | auto_increment |\r\n| score | int | NO | | NULL | |\r\n+-------+------+------+-----+---------+----------------+<\/pre>\n<\/p>\n
\u30c7\u30fc\u30bf\u5185\u5bb9<\/span><\/span><\/h2>\n
mysql> SELECT * FROM `test_table` ORDER BY `score` DESC;\r\n+----+-------+\r\n| id | score |\r\n+----+-------+\r\n| 1 | 100 |\r\n| 4 | 80 |\r\n| 5 | 70 |\r\n| 10 | 70 |\r\n| 3 | 60 |\r\n| 7 | 55 |\r\n| 6 | 50 |\r\n| 2 | 40 |\r\n| 11 | 30 |\r\n| 8 | 20 |\r\n| 9 | 20 |\r\n+----+-------+<\/pre>\n<\/p>\n
\u5bfe\u5fdc\u65b9\u6cd5<\/span><\/h2>\n
SQL\u6587<\/span><\/h3>\n
SELECT score, COUNT(*) AS cnt\r\nFROM `test_table`\r\nGROUP BY `score`\r\nHAVING COUNT(*) >= ALL ( SELECT COUNT(*) AS cnt FROM `test_table` GROUP BY `score`);<\/pre>\n\u51fa\u529b\u7d50\u679c<\/span><\/h3>\n
\u4e0a\u8a18SQL\u6587\u3092\u5b9f\u884c\u3059\u308b\u3068\u4ee5\u4e0b\u304c\u51fa\u529b\u3055\u308c\u308b\u7b48\u3002<\/p>\n
+-------+-----+\r\n| score | cnt |\r\n+-------+-----+\r\n| 70 | 2 |\r\n| 20 | 2 |\r\n+-------+-----+<\/pre>\n<\/p>\n
\u53c2\u8003\u30b5\u30a4\u30c8<\/h2>\n