Characteristics of SQL in DBMS Data Management System

Characteristics of SQL– the main characteristic of the SQL language is that is a declarative or nonprocedural language. This implies that the programmer does not need to specify step-by-step all the operations that the computer needs to carry out to obtain a particular result. Instead, the programmer indicated to the DBMS what needs to be accomplished and then let the system decided on its own how to obtain the desired results. the statement or command that compose the SQL language are generally divided into two major categories or data sublanguages. one of these sub-language known as the data definition language or DDL and the other is known as data manipulation language.

Aggregate function– aggregate functions are functions that takes a collection of values as input and return a single value. In SQL we have a five aggregates function.

  1. Average:avg
  2. Minimum: min
  3. Maximum: max
  4. Count:count
  5. Total: sum

here, sum and function work only for number, while min, max and count work equally well for alphabetic, string

Average: avg– this function take as input, a collection of number and return a single number, which is average of all number.

Example-

  SELECT AVG(amt) FROM orders;

Minimum: min– this is used to find the minimum numbers from a group of numbers. for example, suppose we want to find the amount with the minimum value from the order table.

Example-

select min( amt)

From orders

Count: count-this function is used to return the total number of value in a given attribute, means total count. For example, if we want to find a total number of annum in the order table.

Example- select count(num)

From orders

Total: sum- this is used for to return the sum of number of these numbers

Select sum( amt)

From orders

fwe want to find the sum of amount for each snum seperately.

Select snum,sum(amt)

Group by snum.

Thank you

Share on facebook
Facebook
Share on twitter
Twitter
Share on linkedin
LinkedIn
Share on whatsapp
WhatsApp
Share on reddit
Reddit
Share on telegram
Telegram

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top