Skip to main content

Operators In SQL

Operators In SQL


Operators: SQL generally contains some reserved words that are used to perform operations such as Arithmetical, Comparison and Logical Operations etc. These reserved words are known as Operators.

Generally, there are three types of operators in SQL:

i.      SQL Arithmetic Operators

ii.     SQL Comparison Operators

iii.    SQL Logical Operators

SQL Arithmetic Operators

Let assume variable A holds 20 and variable B holds 60 then:

Operators                             

Description 

  

Example

 

+

Add

 

A+B= will give 80

 

-

Subtract

 

A-B= will give -40

 

*

Multiply

 

A*B= will give 1200

 

/

Division

 

B/A= will give 3

 

%

Modulo

 

B%A= will give 0

SQL Comparison Operator

Let assume variable A holds 20 and variable B holds 60 then:

Operators

Description


Example

=

Examines both operands value that are equal or not, if yes condition becomes true.

 

A=B is not true

!=

This is used to check the value of both operands are equal or not, if not condition become true.

 

A!=B is true

<> 

Examines the operands value equal or not, if not condition become true.

 

A<>B is true

> 

Examines the left operand value is greater than right operand, if yes condition becomes true.

 

A>B is not true

< 

Examines the left operand value is less than right operand, if yes condition becomes true

 

A<B is true

>=

Examines that the value of left operand is greater than or equal to the value of right operand or not, if yes condition become true.

 

A>=B is not true

<=

Examines that the value of left operand is less than equal to the value of right operand or not, if yes condition become true.

 

A<=B is true

SQL Logical Operators

Operators

 

Description

 

  AND

 

Return true if both expressions are true.

 

  OR

 

Return true if either expression is true.

 

  NOT

   Reverse the result of any other Boolean operator.

 

  LIKE

 

Return true if the operand matches a pattern.

 

BETWEEN

   Return true if the operand is within a range.

 
Labels:

Comments

Post a Comment

Popular posts from this blog

Data Types In SQL

  Data Types In SQL W hat is Data Type? A data type as the name suggests it is the type or category to which the data belongs to. A data type specifies a particular type of data, such as integer, floating-point, Boolean, etc. In SQL, the data type defines the type of data to be stored in each column of a table. SQL data types can be broadly divided into three categories 1.       Numeric Data Types 2.       String Data Types 3.       Data & Time Data Types Numeric Data Types String Data Types Data&Time DataTypes BIT CHAR(SIZE) DATE TINYINT VARCHAR(SIZE) TIME SMALLINT TEXT(SIZE) DATETIME MEDIUMINT TINYTEXT(SIZE) TIMESTAMP INT MEDIUMTEXT(SIZE) YEAR BIGINT LONGTEXT   ...
Post a Comment
Read more

Switch Statement In Java

Switch Statement:  The switch statement is just like if-else-if ladder statement. It executes one statement from multiple conditions. It works with a byte, short, int, long, and String. In other words, we can say the Switch case statement is a substitute for a long if statement that compares to several integral values. Syntax of Switch statement in java Enhance Switch or Switch With Arrow: The new syntax uses the -> operator instead of the colon we're used to with switch statements. Also, there's no break keyword. Another addition is the fact that we can now have comma-delimited criteria. Syntax of Enhance Switch in java  
Post a Comment
Read more

Conditional Statements In Java

  Conditionals Statement   A conditional statement  is a set of rules performed if a certain condition is met. A conditional statement begins with the keyword if followed by parentheses. The result of the evaluation is true or false. ·       ‘ if ‘ statement ·       ‘ if-else ‘ statement ·         Nested ‘ if ‘ statement ·       ‘ if-else - if ‘ statement IF statement: ‘IF’ statement is the most basic and simple statement among all the statements. For example- if a value is less than 0, return “Negative value”. Let’s see an example- IF-ELSE statement: The if-else is statement is an extended version of If. Let’s see an example- Nested IF-ELSE statement : In Java, when there is an if statement inside another if statement then it is known as nested if-else. Let’s see an example- IF-ELSE-IF: ‘ if-else-if ’ statement is used when we need to check mul...
Post a Comment
Read more