Skip to main content

Aggregate Functions in SQL

Aggregate Functions

Aggregate Functions : An aggregate function performs a calculation on a set of values, and returns a single value. Except for COUNT, aggregate functions ignore null values. Aggregate functions are often used with the GROUP BY clause of the SELECT statement. aggregate functions return the same value each time that they are called, when called with a specific set of input values.

The following are the commonly used SQL aggregate functions:
  • AVG() – returns the average of a set.
  • COUNT() – returns the number of items in a set.
  • MAX() – returns the maximum value in a set.
  • MIN() – returns the minimum value in a set.
  • SUM() – returns the sum of all or distinct values in a set.

Comments

Post a Comment

Popular posts from this blog

what is a RSA encryption ??

what is a RSA encryption ?? RSA : - Rivest-Shamir-Adleman (these are the name of RSA inventors.) RSA is a encryption algorithm which is used to send message securely in the internet.RSA is a public key algorithm widely used for secure data transmission.In public key algorithm we used two keys for data transmission : one is public and another is private key.We use public key for data encryption and private key for data decryption .  RSA is based on the principle that it is easy to multiply large numbers, but factoring large numbers is very difficult. In RSA, the public key is generated by multiplying two large prime numbers and  together, and the private key is generated through a different process involving  and . A user can then distribute his public key , and anyone wishing to send the user a message would encrypt their message using the public key. Algorithm of RSA :- Choose two large prime numbers P and Q such that P is not equals of Q. Calculate ...
Post a Comment
Read more