问答详情
源自:2-1 [SQL Server基础]T-SQL简介

group by;having;order by

谁能帮我解释一下这三个(group by;having;order by)怎么用

提问者:慕仰9767612 2016-06-17 11:01

个回答

  • 梦瑶行了
    2016-06-17 15:16:37

    group by 用于分组查询 

    select  a,max(b) from tb

    group by a

    having max(b)>**

    order by a