group by order by今天发现一个很有意思的问题,对于一个sql语句,其后的group by 1 order by 1 比如:select to_char(created_date,'%Y%m'),count(*)from aaaagroup by 1 order by 1 其中的created_date为日期格式,该语句想按月
来源:学生作业帮助网 编辑:作业帮 时间:2024/07/10 16:37:04
![group by order by今天发现一个很有意思的问题,对于一个sql语句,其后的group by 1 order by 1 比如:select to_char(created_date,'%Y%m'),count(*)from aaaagroup by 1 order by 1 其中的created_date为日期格式,该语句想按月](/uploads/image/z/9091056-48-6.jpg?t=group+by+order+by%E4%BB%8A%E5%A4%A9%E5%8F%91%E7%8E%B0%E4%B8%80%E4%B8%AA%E5%BE%88%E6%9C%89%E6%84%8F%E6%80%9D%E7%9A%84%E9%97%AE%E9%A2%98%2C%E5%AF%B9%E4%BA%8E%E4%B8%80%E4%B8%AAsql%E8%AF%AD%E5%8F%A5%2C%E5%85%B6%E5%90%8E%E7%9A%84group+by+1+order+by+1+%E6%AF%94%E5%A6%82%EF%BC%9Aselect+to_char%28created_date%2C%27%25Y%25m%27%29%2Ccount%28%2A%29from+aaaagroup+by+1+order+by+1+%E5%85%B6%E4%B8%AD%E7%9A%84created_date%E4%B8%BA%E6%97%A5%E6%9C%9F%E6%A0%BC%E5%BC%8F%2C%E8%AF%A5%E8%AF%AD%E5%8F%A5%E6%83%B3%E6%8C%89%E6%9C%88)
xN@_F IKreT]wE./3SVVPqYLrfwQcaƿƈRPpkpy
.ͷv\oLJiPHBqBwVEd5d4TXz