SQL Operators
has average rating
9
out of 10.
Total 11 users rated.
What is Sql operators?
An operator performs on separate data items and returns a result. The data items are called operands or arguments. Operators are mentioned by special characters or by keywords. For example , the plus operator is represented by an plus (+) sign and the operator that checks for nulls is represented by the keywords IS NULL or IS NOT NULL.
Types of Sql operators
| Sql operators | Description |
|---|---|
| Sql Arithmetic Operator | Arithmetic operators can perform arithmetical operations on numeric operands involved. Arithmetic operators are addition(+), subtraction(-), multiplication(*) and division(/). The + and - operators can also be used in date arithmetic. |
| Sql Comparison Operator | A comparison (or relational) operator is a mathematical symbol which is used to compare between two values. The result of a comparison can be TRUE, FALSE, or UNKNOWN. |
| Sql Boolean operator | The Boolean operators are those that are true or false. They returns a true or false values to combine one or more true or false values. |
| Sql In Operator | The IN operator checks a value within a set of values separated by commas and retrieve the rows from the table which are matching. The IN returns 1 when the search value present within the range other wise returns 0. |
| Sql Between Operator | The SQL BETWEEN operator tests an expression against a range. The range consists of a beginning, followed by an AND keyword and an end expression. The operator returns 1 when the search value present within the range otherwise returns 0. |
| Sql Null Operator | SQL Null check is performed using either IS NULL or IS NOT NULL to check whether a value in a field is NULL or not. |
| Sql Special operator | Some special operators are ANY, ALL, and SOME specifiers can be used as comparison operator to compare for advance queries. The ANY and SOME compares a value to each value in a list or results from a query. It returns no rows when the operators evaluates to false. |
