Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Tuple/Domain Calculus Functions

Posted on 2011-03-06
2
Medium Priority
?
479 Views
Last Modified: 2012-05-11
In tuple/domain calculus, can I use the functions AVERAGE, COUNT, SUM, MAXIMUM, and MINIMUM, or do I need to do something else?
0
Comment
Question by:JCW2
2 Comments
 
LVL 15

Accepted Solution

by:
derekkromm earned 2000 total points
ID: 35051172
sure

you typically use them in conjunction with groupings

so, for example, if you want a list of employees and their total expenses, it'd look like

select employeeid, sum(expense) from expenses group by employeeid

0
 

Author Closing Comment

by:JCW2
ID: 35059483
Thank you for your help.
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this blog post, we’ll look at how using thread_statistics can cause high memory usage.
How much do you know about the future of data centers? If you're like 50% of organizations, then it's probably not enough. Read on to get up to speed on this emerging field.
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses

580 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question