{"id":12008,"date":"2023-11-10T11:17:27","date_gmt":"2023-11-10T10:17:27","guid":{"rendered":"https:\/\/roglacup.com\/klaus62\/?p=12008"},"modified":"2023-11-12T22:40:32","modified_gmt":"2023-11-12T21:40:32","slug":"havin-clause","status":"publish","type":"post","link":"https:\/\/roglacup.com\/klaus62\/2023\/11\/10\/havin-clause\/","title":{"rendered":"HAVING Clause"},"content":{"rendered":"\n<p>The&nbsp;<code>HAVING<\/code>&nbsp;clause is an optional clause of the&nbsp;<code><a href=\"https:\/\/www.oracletutorial.com\/oracle-basics\/oracle-select\/\">SELECT<\/a><\/code>&nbsp;statement. It is used to filter groups of rows returned by the&nbsp;<a href=\"https:\/\/www.oracletutorial.com\/oracle-basics\/oracle-group-by\/\"><code>GROUP BY<\/code><\/a>&nbsp;clause. This is why the&nbsp;<code>HAVING<\/code>&nbsp;clause is usually used with the&nbsp;<code>GROUP BY<\/code>&nbsp;clause.<\/p>\n\n\n\n<p>Posted from: <a href=\"https:\/\/www.oracletutorial.com\/oracle-basics\/oracle-having\/\">https:\/\/www.oracletutorial.com\/oracle-basics\/oracle-having\/<\/a><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"534\" src=\"https:\/\/roglacup.com\/klaus62\/wp-content\/uploads\/2023\/11\/image-6-1024x534.png\" alt=\"\" class=\"wp-image-12009\" srcset=\"https:\/\/roglacup.com\/klaus62\/wp-content\/uploads\/2023\/11\/image-6-1024x534.png 1024w, https:\/\/roglacup.com\/klaus62\/wp-content\/uploads\/2023\/11\/image-6-300x156.png 300w, https:\/\/roglacup.com\/klaus62\/wp-content\/uploads\/2023\/11\/image-6-768x400.png 768w, https:\/\/roglacup.com\/klaus62\/wp-content\/uploads\/2023\/11\/image-6.png 1401w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"467\" src=\"https:\/\/roglacup.com\/klaus62\/wp-content\/uploads\/2023\/11\/image-7-1024x467.png\" alt=\"\" class=\"wp-image-12010\" srcset=\"https:\/\/roglacup.com\/klaus62\/wp-content\/uploads\/2023\/11\/image-7-1024x467.png 1024w, https:\/\/roglacup.com\/klaus62\/wp-content\/uploads\/2023\/11\/image-7-300x137.png 300w, https:\/\/roglacup.com\/klaus62\/wp-content\/uploads\/2023\/11\/image-7-768x350.png 768w, https:\/\/roglacup.com\/klaus62\/wp-content\/uploads\/2023\/11\/image-7.png 1499w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><strong>Which two statements are true about the WHERE and HAVING clauses in a SELECT statement? (Choose two.)<\/strong><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p>A.&nbsp;Aggregating functions and columns used in HAVING clauses must be specified in the SELECT list of a query<\/p>\n\n\n\n<p>Primer : <\/p>\n\n\n\n<p>SELECT dno, MIN(salary) AS &#8220;Lowest salary&#8221; FROM employee GROUP BY dno HAVING MAX(salary) &gt; 40000<\/p>\n\n\n\n<p>B.&nbsp;WHERE and HAVING clauses can be used in the same statement only if applied to different table columns<\/p>\n\n\n\n<p><strong>C.&nbsp;The HAVING clause can be used with aggregating functions in subqueries<\/strong><\/p>\n\n\n\n<p><strong>D.&nbsp;The WHERE clause can be used to exclude rows before dividing them into groups<\/strong><\/p>\n\n\n\n<p>E.&nbsp;The WHERE clause can be used to exclude rows after dividing them into groups<\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>The&nbsp;HAVING&nbsp;clause is an optional clause of the&nbsp;SELECT&nbsp;statement. It is used to filter groups of rows returned by the&nbsp;GROUP BY&nbsp;clause. This is why the&nbsp;HAVING&nbsp;clause is usually used with the&nbsp;GROUP BY&nbsp;clause. Posted from: https:\/\/www.oracletutorial.com\/oracle-basics\/oracle-having\/ Which two statements are true about the WHERE and HAVING clauses in a SELECT statement? (Choose two.) A.&nbsp;Aggregating functions and columns used in&hellip;&nbsp;<a href=\"https:\/\/roglacup.com\/klaus62\/2023\/11\/10\/havin-clause\/\" class=\"\" rel=\"bookmark\">Read More &raquo;<span class=\"screen-reader-text\">HAVING Clause<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":12151,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"neve_meta_sidebar":"","neve_meta_container":"","neve_meta_enable_content_width":"","neve_meta_content_width":0,"neve_meta_title_alignment":"","neve_meta_author_avatar":"","neve_post_elements_order":"","neve_meta_disable_header":"","neve_meta_disable_footer":"","neve_meta_disable_title":"","footnotes":""},"categories":[1299],"tags":[1330],"class_list":["post-12008","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-1z0-082","tag-having-clause"],"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/posts\/12008","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/comments?post=12008"}],"version-history":[{"count":3,"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/posts\/12008\/revisions"}],"predecessor-version":[{"id":12152,"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/posts\/12008\/revisions\/12152"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/media\/12151"}],"wp:attachment":[{"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/media?parent=12008"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/categories?post=12008"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/tags?post=12008"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}