Operation statement collation of SQL operator
This article mainly explains "the operation statement arrangement of SQL operator". The content of the explanation in the article is simple and clear, and it is easy to learn and understand. now please follow the editor's train of thought to study and learn "the operation statement arrangement of SQL operator".
Operators in SQL
1 arithmetic operator:
+: addition operation, find the sum of two numbers or expressions to add -: subtraction operation, find the difference of subtraction of two numbers or expressions *, multiplication operation, find the product /: division operation of the multiplication of two numbers or expressions, find the quotient of the division of two numbers or expressions%: modular operation, find the remainder of the division of two numbers or expressions
two。 Assignment operation
Assign one number or expression to another scalar.
3. Comparison operator
=: equal to > greater than
< 小于 不等于 >= greater than or equal to
