Aggregate Functions and Group By Clause Oracle with Examples. Hello Everyone, Today I will discuss about Aggregate function in SQL by using Group By Clause and different clauses with some examples . Please go tjrough my previous blogs in Archive folder for classification of SQL, Commands and SQL joins for your understanding. Aggregate Functions Allows us to perform a calculation on a set of values to return a single value . We can use Group by Clause to group the result-set by one or more columns. Also we can use Having clause to restrict or filter the data as per our requirement. Note: Whenever we use Aggregate function in SQL we can’t able to use where condition. To restrict or filter the record we need to use having clause instead of Where. Below is the most commonly used Aggregate function in SQL. MAX : Max function used to get the maximum values in a set of values. COUNT : This function used to count rows in ...
Diksha Oracle Training Centre is a platform for IT Graduate as it provides both offline and online training to IT graduate to excel/his her carrier in IT industry.