it is also possible to calculate more complex aggregate functions which combine the values of several columns.
noun /'æɡrɪɡət/
1
the total after a lot of different figures or points have been added together
a total amount
a total number or amount made up of smaller amounts that are collected together
something formed by adding together several amounts or things; a total
the total of several things or numbers
the total scored in a set of games
An aggregate is a number of people or things that are being considered as a single thing.
If a number of different things or amounts are considered in aggregate, or in the aggregate, they are considered as a single thing or amount. Syn:in total
If one team beats another on aggregate, it wins because it has a higher total score than the other team after a series of games.
aggregate of
The smaller minorities got an aggregate of 1,327 votes.
In the aggregate(=as a group or in total), women outlive /ˌaʊt'lɪv/ men by 7 or more years.
on aggregate(=when the points from two football games are added together)
Manchester/'mæntʃɪstə/ United won 2–1 on aggregate.
We spent an aggregate of 30 million dollars in advertising during the last three years.
They won the two games by an aggregate of 40 points.
Dividends/'dɪvɪdɛnd/ for the year amounted in the aggregate to 25 million dollars.
The experience only becomes important when considered in the aggregate.
Our team won the same number of matches, but their team scored more goals so they won on aggregate.
a record aggregate of 285 points
The three smaller parties gained an aggregate of 25 per cent of the vote.
when the scores of a number of games are added together
in the aggregate(added together as a total or single amount)
Businesses are, in the aggregate, deeper in debt than ever before.
on aggregate( when the scores of a number of games are added together)
They won 4–2 on aggregate.
They purchased an aggregate of 3000 shares in the company.
Snowflakes are loose aggregates of ice crystals /'krɪstl/.
Arsenal lost the second game, but got through to the final on aggregate (= adding together the goals in both matches).
The charity/'tʃærəti/ received gifts, which in aggregate did not exceed £40,000.
Liverpool won 11–2 on aggregate.
The highest aggregate came in the third round where Leeds and Middlesbrough drew 4-4.
society viewed as an aggregate of individuals.
Expenses are deductible only to the extent that in aggregate they exceed 7 percent of gross income.
United won 5-3 on aggregate.
2
sand or small stones that are used in making concrete /'kɑŋkrit/
sand or broken stone that is used to make concrete or for building roads, etc.
sand or small stones used for making concrete (=material used for building)
adjective /'æɡrɪɡət/
being the total amount of something after all the figures or points have been added together
formed by adding together two or more amounts
made up of several amounts that are added together to form a total number
total
used for describing the total amount of something in a country’s economy
An aggregate amount or score is made up of several smaller amounts or scores added together.
an increase in the aggregate production
The university receives more than half its aggregate income from government sources.
The team with the highest aggregate score wins.
aggregate demand/investment/turnover
an aggregate win over their rivals
The seven companies have an aggregate turnover of £5.2 million.
the aggregate value of all shares purchased
aggregate demand/supply:
an increase in aggregate demand for the fourth quarter
The rate of growth of GNP will depend upon the rate of growth of aggregate demand...
England have beaten the Welsh three times in succession with an aggregate score of 83-12.
verb /'æɡrɪɡet/
1
to be a particular amount when added together
to equal a specified number or amount
to add amounts together
Sheila’s earnings from all sources aggregated £100,000.
All together, they had profits aggregating [=totaling] more than 10 million dollars
2
to put different amounts, pieces of information etc together to form a group or a total
GRAMMAR Aggregate is usually passive in this meaning, when used as a transitive verb.
to join or combine into a single group
to put together different items, amounts, etc. into a single group or total
to combine into a single group or total
to put things together in a group
If amounts or things are aggregated, they are added together and considered as a single amount or thing.
aggregate with
A wife’s income is no longer aggregated with that of her husband.
The Web site aggregates content from many other sites.
These insects tend to aggregate [=congregate] in dark, moist/mɔɪst/ places.
The scores were aggregated with the first round totals to decide the winner.
Different economies, with different currencies, should not be aggregated to produce uniform policies....
We should never aggregate votes to predict results under another system.
aggregation noun /ˌæɡrɪˈɡeɪʃən/
the aggregation of data
A bigger objection is that aggregation of the results invites distortion.
网友评论