Shulou(Shulou.com)05/31 Report--

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

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.