12. SQL Basic collation (operator and priority)

Operator

+ - * / %( take surplus) , assignment operator =

DECLARE @jia int

Set @jia =

Print @jia

DECLARE @jia int

Set @jia = 10%3

Print @jia

comparison Operators >, <, >=, <=,<> ( not equals ),! =,!<,!>

? the logical operator and , or, all (conditions are all satisfied ) , any (one condition satisfies ), between ( Range ), in ( any one condition satisfies ), like, not ( non ), some ( any one condition satisfies ), exists ( sub-query )

*all (modifier, which represents all the column element data to satisfy the subquery, used with the comparison operator)

Not can be used in conjunction with In,like to indicate that it is not in a range, or unlike a certain wildcard value

Priority level:

*%/

positive or negative + - 

Comparison operators

Not and or between

All, a, some, in, like, exists =

Unary operator: " + , - "represents the positive or negative of the number, the negative sign is best used when parentheses, otherwise easily as a minus action

12. SQL Basic collation (operator and priority)