mysql 与sqlser group by

mysql 

    select * ,count(1)  from simccbillm18 group by MonthNum; 

SqlSer

 select  col1,col2 from table group by col1 ,col2