PL/SQL中SELECT总结
<div id="cnblogs_post_body">一、SELECT 语句的各个关键词的顺序及作用简解（这个我简略点写~）1.SELECT
2.FROM
3.WHERE
4.GROUP BY ---对结果集进行分组，通常与聚合函数一起使用
5.HAVING
6.ORDER BY
举个例子如下：
<div class="cnblogs_code">select item_name,count(item_name) from lab_item_dictwhere price='25'group by item_namehaving count(item_name)>1 order by count(item_name);
页:
[1]