Home >> SQL >> Comparison Operators in SQL

Comparison Operators in SQL

Operator          Description                  Example(a=20,b=10)
  =                     Equal                          (a = b) return not true.
 !=                     Not Equal                   (a != b) return true.
 <>                    Not                              (a <> b) return true.
 >                      Greater Than              (a > b) return not true.
 >=                    Greater Than Equals  (a >= b) return not true.
 <                       Less Than                  (a < b) return true.
 <=                     Less Than Equals      (a <= b) return true.

Post Your Comment

Next Questions
Logical Operators
What is key
What is super key
What is candidate key
What is primary key
What is unique key
What is foreign key
What is join
What is cross join
What is natural join
What is outer join
What is self join
What is aggregate function
COUNT(*) aggregate function
AVG() aggregate function
MIN() aggregate function
MAX() aggregate function
SUM() aggregate function
STDED() aggregate function
CONCAT() function
GROUP_CONCAT() function
CONCAT_WS() function
CHECKSUM_AGG() aggregate function
ABS(n) aggregate function
POWER(m,n) aggregate function

Copyright ©2022 coderraj.com. All Rights Reserved.