huaxingao commented on a change in pull request #27284: [SPARK-30575][DOC]
Document HAVING Clause of SELECT statement in SQL Reference
URL: https://github.com/apache/spark/pull/27284#discussion_r368357449
##########
File path: docs/sql-ref-syntax-qry-select-having.md
##########
@@ -18,5 +18,101 @@ license: |
See the License for the specific language governing permissions and
limitations under the License.
---
+The <code>HAVING</code> clause is used to filter the results produced by
+<code>GROUP BY</code> based on the specified condition. It is often used
+in the conjunction with a <code>GROUP BY</code> clause.
-**This page is under construction**
+### Syntax
+{% highlight sql %}
+HAVING boolean_expression
+{% endhighlight %}
+
+### Parameters
+<dl>
+ <dt><code><em>boolean_expression</em></code></dt>
+ <dd>
+ Specifies any expression that evaluates to a result type
<code>boolean</code>. Two or
+ more expressions may be combined together using comparision operators
+ ('>', '>=', ‘>’, ‘>=’, ‘=’, ‘<’ and ‘<=’, '<=>') and logical operators
(AND, NOT, OR).<br><br>
Review comment:
This doesn't look right:
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
[email protected]
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
