CodesJava

Easy learning with example program codes

SQL operators


Operator:

An operator is a special symbol which used to perform a specific operation.

SQL operators:

SQL operators are the reserved words or special symbols or characters that are used to perform specific operations.

Types of SQL operators:

  1. SQL Arithmetic Operators
  2. SQL Comparison Operators
  3. SQL Logical Operators

1. SQL Arithmetic Operators:

Let us consider the two variables a and b, where a hold 20 and b hold 40.

Operator Description Example
+ It is used to add the operands values. a + b will give 60
It is used to subtract right hand operand from left hand operand. a – b will give -20
* It is used to multiply the operands values. a * b will give 800
/ It is used to divide left hand operand by right hand operand b / a will give 2
% It is used to modulo divide left hand operand by right hand operand. b % a will give 0

 

2.   SQL Comparison Operators:

Let us consider the two variables a and b, where a hold 20 and b hold 40.

Operator Description Example
= It is used to check that the values of two operands are equal or not, if yes then condition becomes true. (a = b) is not true.
!= It is used to check that the values of two operands are equal or not, if values are not equal then condition becomes true. (a != b) is true.
<> It is used to check that the values of two operands are equal or not, if values are not equal then condition becomes true. (a <> b) is true.
> It is used to check that the value of left operand is greater than the value of right operand, if yes then condition becomes true. (a > b) is not true.
< It is used to check that the value of left operand is less than the value of right operand, if yes then condition becomes true. (a < b) is true.
>= It is used to check that the value of left operand is greater than or equal to the value of right operand, if yes then condition becomes true. (a >= b) is not true.
<= It is used to check that the value of left operand is less than or equal to the value of right operand, if yes then condition becomes true. (a <= b) is true.
!< It is used to check that the value of left operand is not less than the value of right operand, if yes then condition becomes true. (a !< b) is false.
!> It is used to check that the value of left operand is not greater than the value of right operand, if yes then condition becomes true. (a !> b) is true.

 

3.   SQL Logical Operators

Operator Description
ALL It is used to compare a value to all values in another value set.
AND It allows the existence of multiple conditions in an SQL statement’s WHERE clause.
ANY It is used to compare a value to any applicable value in the list according to the condition.
BETWEEN It is used to search for values that are within a set of values, given the minimum value and the maximum value.
EXISTS It is used to search for the presence of a row in a specified table that meets certain criteria.
IN The IN operator is used to compare a value to a list of literal values that have been specified.
LIKE It is used to compare a value to similar values using wildcard operators.
NOT It reverses the meaning of the logical operator with which it is used. Eg: NOT EXISTS, NOT BETWEEN, NOT IN, etc. This is a negate operator.
OR It is used to combine multiple conditions in an SQL statement’s WHERE clause.
IS NULL It is used to compare a value with a NULL value.
UNIQUE It searches every row of a specified table for uniqueness (no duplicates).

 
Next Topic: SQL CREATE Database with example.
Previous Topic: SQL data type.

Related Topics:

How to build java project using ant in eclipse?
JAXB marshalling – convert java object to xml example.
How to create pdf file in java using iText jar?
Generics class example.
OGNL in struts 2.
Hibernate One-to-One Mapping using xml.
Send inline image in email using JavaMail API.
Quartz 2 JobListener example.

 

Sign Up/ Sign In
Ask a Question


Industrial Training

We offers Placement Oriented Training on Java, Spring, JSF, Hibernate, PHP, AngularJS, Angular 4, PLSQL, Oracle BI Publisher etc. We also provides Online training, please mail us at hr@codesjava.com.

Development

We also provides the Development services for Website Development , Java Development, PHP Development, Android App Development etc. You can contact us on hr@codesjava.com.

Copyright © 2018 CodesJava DMCA.com Protection Status SiteMap Reference: Java Wiki