{"author_name":"fyts","blog_url":"https://fyts.hatenadiary.org/","url":"https://fyts.hatenadiary.org/entry/20080417/quiz","provider_url":"https://hatena.blog","published":"2008-04-17 00:00:00","title":" SQL \u30af\u30a4\u30ba: GROUP BY \u3068 COUNT(*) -- \u554f\u984c\u7de8","blog_title":"\u30a2\u30b8\u30e3\u30a4\u30eb\u30d7\u30ed\u30b0\u30e9\u30de\u306e\u65e5\u5e38","author_url":"https://blog.hatena.ne.jp/fyts/","version":"1.0","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Ffyts.hatenadiary.org%2Fentry%2F20080417%2Fquiz\" title=\" SQL \u30af\u30a4\u30ba: GROUP BY \u3068 COUNT(*) -- \u554f\u984c\u7de8 - \u30a2\u30b8\u30e3\u30a4\u30eb\u30d7\u30ed\u30b0\u30e9\u30de\u306e\u65e5\u5e38\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","image_url":null,"description":"\u3061\u3087\u3063\u3068\u8da3\u5411\u3092\u5909\u3048\u3066 SQL \u30af\u30a4\u30ba\u3067\u3082\u51fa\u3057\u3066\u307f\u307e\u3059\u3002\u4ee5\u4e0b\u306e\u30c6\u30fc\u30d6\u30eb\u304c\u3042\u308b\u3068\u304d\u3001\u5909\u6570\u306b\u4ee3\u5165\u3057\u305f COUNT(*) \u306e\u7d50\u679c\u306f\u3069\u3046\u306a\u308b\u3067\u3057\u3087\u3046\u304b\u3002\u610f\u5916\u3068\u9a5a\u304f\u7d50\u679c\u306b\u306a\u308b\u304b\u3082\u3057\u308c\u307e\u305b\u3093\u3002 SELECT * FROM Employee /* EmployeeID EmployeeName CountryID ----------- ------------- ---------- E001 \u5c71\u7530 C001 E002 \u9234\u6728 C004 E003 \u4e2d\u6751 C001 E004 \u5c71\u672c C001 */ DECLARE @ret1 int SET @ret1 = 999 SELECT @ret1 = COUNT(*) \u2026","width":"100%","height":"190","type":"rich","provider_name":"Hatena Blog","categories":["\u958b\u767a","SQL","Tips"]}