Oracle PLSQL Tutorial Aggregate Functions 50 codes

1 AVG(x) gets the average value of x

2 Compare the difference between count() and count(distinct course)

3 Count all employees by evenodd employee id

4 Count column with table alias

5 Count date field value, and calculation

6 Count department and calculate average salary

7 Count distinct column value

8 Count employees in the same department

9 Count() - count(onhand)

10 Count() vs count(column name)

11 COUNT() with null

12 COUNT(1) from a table

13 COUNT(x) gets the number of rows returned by a query

14 Get median salary

15 Greater than average salary

16 Greater than max(salary)

17 GROUP by with NULL value

18 Grouping Rows with the GROUP BY Clause to get some information on those groups of rows

19 Incorrect Usage of Aggregate Function Calls

20 JOIN with AND and aggregate function

21 List employee whose salary is higher than the average salary

22 List the employees whose salary is higher than the average salary with subquery

23 Max and decode function

24 Max(total_price) - min(total_price)

25 MAX(x) gets the maximum values for x

26 MEDIAN(x) returns the median value of x

27 MIN(x) gets the minimum values for x

28 Passes ROWID to COUNT() and gets the number of rows

29 STDDEV(x) get the standard deviation of x

30 Sum column for a certain time period

31 Sum salary group by department number

32 Sum with group by cude

33 Sum with null value

34 Sum() function and having clause

35 SUM(x) adds all the values in x and returns the total

36 Use AVG

37 Use count, sum, avg, median

38 Use MAX() with dates

39 Use MAX() with strings

40 Use MIN() with dates

41 Use MIN() with strings

42 Use the aggregate functions with valid expression

43 Use the DISTINCT keyword to exclude identical values from a group computation

44 Using Aggregate Functions

45 Using an aggregate with the GROUP BY clause to count by city

46 Using avg() function in having clause

47 Using Groups of Rows with Aggregate Functions

48 VARIANCE(x) gets the variance of x

49 Who have the max value

50 You cannot use an aggregate function to limit rows in a WHERE clause