📄 exp_112.htm

📁 oracle　DBA的资料

💻 HTM

字号:

<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=gb2312">
<title>Ocp test </title>
</head>
<body bgcolor="white" text="black" link="blue" vlink="purple" alink="red">
<p><b><span style="font-size:22pt">Explaination 112: &nbsp;</span></b></p>


	<p>
	<span style="font-size:18pt">HAVING clause to specify which groups are to be displayed and thus further restrict the groups on the basis of aggregate information.The Oracle server performs the following steps when you use the Having clause <br>
	</span></p>

	<p>
	  <span style="font-size:18pt">1. rows are grouped <br>
		  2. the group function is applied to the group 3. the group that match the criteria in the Having clause are displayed. <br>
	  WHERE clause cannot be use to restrict groups HAVING clause use to restrict groups <br>WHERE clause cannot be use when there is group functions. <br>
	</span></p>

	<p>
	  <span style="font-size:18pt">Incorrect Answers : <br>
	</span></p>

	<p>
	   <span style="font-size:18pt"><br></span></p>

	<p>
	  <span style="font-size:18pt">A. Where clause cannot be use to restrict groups <br>
	</span></p>

	<p>
	  <span style="font-size:18pt">D. When HAVING clause is use rows are grouped as well. <br>
	</span></p>

	<p>
	  <span style="font-size:18pt">E. WHERE clause cannot be use when there is group function, instead HAVING is to be use. <br>
	</span></p>

	<p>
	  <span style="font-size:18pt">F. There is no constraint to use HAVING clause in a subqueries. <br>
	</span></p>

	<p>
	  <span style="font-size:18pt">Refer : Introduction to Oracle9i : SQL, Oracle University Student Guide, Aggregating Data <br>
	</span></p>

	<p>
	  <span style="font-size:18pt">using Group Functions, p. 5-20
	</span></p>



</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -