{"author_url":"https://blog.hatena.ne.jp/HTN20190109/","description":"MySQL (8.0.32) drop table tab1;create table tab1(col1 int);insert into tab1 values(1);insert into tab1 values(1);insert into tab1 values(2);insert into tab1 values(2); select * from tab1;select col1,count(*) from tab1 group by 1;select count(*),col1 from tab1 group by 2; \u6570\u5024\u6307\u5b9a\u53ef\u80fd Oracle (19c) drop tab\u2026","categories":["DB"],"provider_url":"https://hatena.blog","type":"rich","provider_name":"Hatena Blog","title":"group by \u306e\u6570\u5024\u6307\u5b9a","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fhtn20190109.hatenablog.com%2Fentry%2F2023%2F02%2F20%2F232325\" title=\"group by \u306e\u6570\u5024\u6307\u5b9a - HTN20190109\u306e\u65e5\u8a18\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","blog_url":"https://htn20190109.hatenablog.com/","author_name":"HTN20190109","blog_title":"HTN20190109\u306e\u65e5\u8a18","width":"100%","version":"1.0","published":"2023-02-20 23:23:25","url":"https://htn20190109.hatenablog.com/entry/2023/02/20/232325","image_url":null,"height":"190"}