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 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.|