Aggregate And Numeric Functions SQL has many built-in functions for performing processing on string or numeric data. ➥ AGGREGATEE FUNCTIONS:- ➧ Average function : Returns average value of 'n', ignoring null values. Example: SE LECT AVG(sell_price) from product; ➧ COUNT :Counts rows in a specified table or view. Example: SELECT COUNT ( * ) FROM products ; ➧ MIN : G ets the minimum value in a set of values. Example: SELECT MIN ( unitsinstock ) FROM products ; ➧ MAX : Gets the maximum value in a set of values. Example: SELECT MAX ( unitsinstock ) FROM products ; ➧ SUM :Ca lculates the sum of values Example:SELECT ...
Learn SQL from basic to advance.