SQL Session for Beginners:
The third part of SQL Series where we will cover following topics:
Under SQL Basics we will see - Min & Max, Sum, IN, Count, Like, Aliases, Average and Between
MIN() Function is used to find out the record with minimum value among a record set.
MAX() Function is used to find out the record with maximum value among a record set.
SUM function is used to return the sum of an expression in a select statement.
COUNT function is used to count the number of rows returned in a select statement.
SQL aliases are used to give a table or a column in a table, a temporary name.
The AVG() function returns the average value of a numeric column.
The BETWEEN operator selects values within a given range. The values can be numbers, text, or dates.
