AGGREGATE FUNCTIONS DBMS

-

 In DBMS, aggregate functions are used to combine multiple values of rows to get a single meaningful value. 

Various Aggregate functions are:

Count():

  • Count(*): Returns the total number of records
  • Count(column_name): Returns the total number of non-null values in the column.
  • Count(distinct column_name): Returns the total number of distinct non-null values in the column.

Sum():

  • Sum(column_name): Sum of all non-null values in the column
  • Sum(distinct column_name): Sum of all distinct non-null values in the column

Avg():

  • Avg(salary) = Sum(salary) / count(salary) = 310/5
  • Avg(Distinct salary) = sum(Distinct salary) / Count(Distinct Salary) = 250/4

 

Min():

  • Min(salary): Minimum value in the salary column except
    NULL i.e., 40.
  • Max(salary): Maximum value in the salary i.e., 80.

Comments

Post a Comment

Popular posts from this blog

Python Syntax, Comments, Variables, Indentation

-
Execute Python Syntax As we learned in the past page, Python grammar can be executed by composing straightforwardly in the Command Line: >>> print("Hello, World!") Hello, World!  Or on the other hand by making a python record on the server, utilizing the .py document augmentation, and running it in the Command Line: C:\Users\ Your Name >python myfile.py  Python Indentation Space alludes to the spaces toward the start of a code line. Where in other programming dialects the space in code is for lucidness just, the space in Python is vital. Python utilizes space to show a square of code. if 5 > 2 :   print ( "Five is greater than two!" )   Python Variables In Python, factors are made when you relegate a worth to it: x = 5 y = "Hello, World!"   Python has no order for proclaiming a variable. Comments Python has remarking capacity with the end goal of in-code documentation. Remarks start with a #, and Python will deliver the remainder ...
Read more

THREE LEVELS OF DATA INDEPENDENCE

-
Image
THREE LEVELS OF DATA INDEPENDENCE It divides the entire system into three inter-related but independent modules: Physical Level: Here, information about the location of database objects in the data store is kept. Various DBMS users are unaware of the locations of these objects. The Physical level of database describes how the data is stored in secondary storage devices such as disks and tapes. Conceptual Level: Here, data is represented in the form of various tables. For Example, STUDENT database may contain NAME and COURSE tables, but the users are unaware of their storage. It refers to what kind of data to be stored in a database. External Level: Here, it specifies the view of data in terms of conceptual level tables. It can generate different views of the database for different users. It focuses main on data abstraction.  Data Independence: It means change of data at one level must not affect the another level. Physical Data Independence: Any change in the physical location of t...
Read more

NESTED QUERIES DBMS

-
Image
In Nested Queries , a query is written inside a query. The result of inner query is used in the execution of the outer query. There are mainly two types of nested queries: Independent Nested Queries: In independent nested queries, query execution starts from inner query to outer query. The execution of inner query is independent of the outer query, but the result of inner query is used in the execution of the outer query.                            For Example: select S_NAME from STUDENT where S_ID IN                                                                                                                        ...
Read more