SQL is known as Structural Query Language. It is a programming language. SQL is a domain-specific language used in programming and designed for managing data held in a relational database management system, or for stream processing in a relational data stream management system.
SQL FUNCTIONS
A function is a predefined command set that performs some operation and returns the single value.
• SQL provides variety of functions which can be categorised into two types of functions:
•Single Row functions.
•Multiple Row functions.
Single Row Functions
- Single Row Functions operate on a single value to return a single value. They can accept one or more arguments but return only one result per row. When applied on a table, they return result for every row of the queried table.
They are further categorized into :
- Numeric functions
- Character and String functions
- Date and Time functions.
Multiple Row Functions
- Multiple Row Functions (also called aggregate functions). Multiple row functions operate on a set of rows to return a single value.
These functions are as under :
AVG ( ) - Returns the average value.
COUNT ( ) - Returns the number of rows.
FIRST ( ) - Returns the first value.
LAST ( ) - Returns the last value.
MAX ( ) - Returns the largest value.
MIN ( ) - Returns the smallest value.
SUM ( ) - Returns the sum.
If you got to know anything from this article. So you can like this article.
And if you find anything bad in this article. Or do you want to improve anything in this article. You comment in the comment box of this article. So that we can improve our upcoming articles. To visit the Website at last Thanks.
Thanks You again for Visiting our Website. Please Visit Again.
1 Comments
Nice 👍🏻
ReplyDelete