SqlServer 中 Group by、having、order by、Distinct 使用注意事项

艾编程

<div id="cnblogs_post_body">直奔主题，如下SQL语句：
<div class="cnblogs_code">SELECT COUNT(*) AS COUNT,REQUEST,METHOD FROM REQUESTMETH GROUP BY REQUEST,METHOD HAVING (REQUEST ='FC.OCEAN.JOB.SERVER.CBIZOZBKHEADER' OR REQUEST='FC.Ocean.Job.Server.CBizOzDocHeader')AND COUNT(*) >3ORDER BY REQUEST