form子句语法错误_用示例语法解释SQL的子句

form子句语法错误

HAVING gives the DBA or SQL-using programmer a way to filter the data aggregated by the GROUP BY clause so that the user gets a limited set of records to view.

HAVING为DBA或使用SQL的程序员提供了一种过滤由GROUP BY子句聚合的数据的方法，以便用户可以查看一组有限的记录。

使用例 (Example of use)

The HAVING clause is like the WHERE clause, except it acts on the grouped data. In this case, the user will only see the largest amounts.

HAVING子句与WHERE子句类似，不同之处在于它对分组的数据起作用。 在这种情况下，用户只会看到最大的金额。

This data is from the campaign contributions data we’ve been using in some of these guides.

此数据来自我们在其中一些指南中一直使用的广告系列贡献数据。

This SQL statement is answering the question: “which candidates received the largest total contributions in 2016 BUT only those that had more than 8$20 Million USD?”

该SQL语句回答了以下问题：“哪些候选人在2016年BUT中获得的捐款最多，只有那些收入超过8千万美元的候选人？”

Ordering this data set in a descending (DESC) order places the candidates with the largest total contributions at the top of the list.

按降序(DESC)排序此数据集，将总贡献最大的候选者放在列表的顶部。

SELECT Candidate, Election_year, sum(Total_$), count(*)
FROM combined_party_data
WHERE Election_year = 2016
GROUP BY Candidate, Election_year -- this tells the DBMS to summarize by these two columns
HAVING sum(Total_$) > 20000000  -- limits the rows presented from the summary of money ($20 Million USD)
ORDER BY sum(Total_$) DESC; -- orders the presented rows with the largest ones first.

+--------------------------------------------------+---------------+-------------------+----------+
| Candidate                                        | Election_year | sum(Total_$)      | count(*) |
+--------------------------------------------------+---------------+-------------------+----------+
| CLINTON, HILLARY RODHAM & KAINE, TIMOTHY M (TIM) |          2016 | 568135094.4400003 |      126 |
| TRUMP, DONALD J & PENCE, MICHAEL R (MIKE)        |          2016 | 366853142.7899999 |      114 |
| SANDERS, BERNARD (BERNIE)                        |          2016 |      258562022.17 |      122 |
| CRUZ, RAFAEL EDWARD (TED)                        |          2016 | 93430700.29000005 |      104 |
| CARSON, BENJAMIN S (BEN)                         |          2016 | 62202411.12999996 |       93 |
| RUBIO, MARCO ANTONIO                             |          2016 |        44384313.9 |      106 |
| BUSH, JOHN ELLIS (JEB)                           |          2016 |       34606731.78 |       97 |
+--------------------------------------------------+---------------+-------------------+----------+
7 rows in set (0.01 sec)

As with all of these SQL things there is MUCH MORE to them than what’s in this introductory guide.

与所有这些SQL事物一样，它们比本入门指南中的内容要多得多。

I hope this at least gives you enough to get started.

我希望这至少能给您足够的入门。

Please see the manual for your database manager and have fun trying different options yourself.

请参阅数据库管理员的手册，并尝试自己尝试其他选项，这很有趣。

翻译自: https://www.freecodecamp.org/news/the-sql-having-clause-explained-with-example-syntax/

form子句语法错误