Friday 27 October 2017

What are the Aggregate Functions in Oracle SQL

Aggregate Functions


MINreturns the smallest value in a given column
MAXreturns the largest value in a given column
SUMreturns the sum of the numeric values in a given column
AVGreturns the average value of a given column
COUNTreturns the total number of values in a given column
COUNT(*)returns the number of rows in a table

Aggregate functions are used to compute against a "returned column of numeric data" from your SELECT statement. They basically summarize the results of a particular column of selected data.
-

1 comment:

  1. Phani M29 March 2021 at 21:31

    Hello , Would you mind sharing your contact email/phone number ? I need some info on Process Mfg

    ReplyDelete

Subscribe to: Post Comments (Atom)

Script to update salespersons customer site wise in oracle apps R12

SELECT * FROM HZ_PARTIES WHERE PARTY_NAME LIKE 'DEENA VISION%'; SELECT * FROM HZ_CUST_ACCOUNTS_ALL WHERE PARTY_ID =94043 ; SE...