Software Testing Material

A site for software testers. We provide free online tutorials on Manual Testing, Automation Testing - Selenium, QTP, LoadRunner, Testing Tools and many more.

  • Blog
  • Tutorials
    • Manual Testing
    • Java
    • Selenium
      • TestNG
      • Maven
      • Jenkins
    • Framework
    • Katalon
    • Agile
    • SQL
    • VBScript
    • API Testing
  • Tools
    • TestLodge
    • FrogLogic GUI Tool
    • CrossBrowserTesting
    • BrowserStack
    • TestCaseLab
    • Kobiton
    • Sikuli
    • Postman
  • Interview Q & A
    • Selenium
    • TestNG
    • Test Framework
    • Explain Framework
    • Manual Testing
    • Software QA
    • Agile
    • Testing As A Career
    • General Interview Questions
    • API Testing
    • SOAP
  • Free Resources
  • Guest Post
    • Guest Post Guidelines
  • Training

SQL Operators – SQL Tutorial | Software Testing Material

Last Updated on April 4, 2017 by Rajkumar

SQL Operators:

In this post, we see SQL Operators in detail.

SQL Operator is a reserved word used primarily in an SQL statement’s WHERE clause to perform operations, such as arithmetic operations and comparisons. These are used to specify conditions in an SQL statement.

There are are three types of Operators.

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

SQL Arithmetic Operators:

Let’s assume two variables “x” and “y”. Here “x” is valued 30 and “y” valued 60.

In SQL, we use Arithmetic operators such as +, –, *, /, %.

To add two numbers we use the operator +: 

Based on the above mentioned values of x and y.

1
x+y = 30+60 = 90.

Check the below image for the description of each operator.

SQL Arithmetic Operators

SQL Comparison Operators:

Let’s assume two variables “x” and “y”. Here “x” is valued 30 and “y” valued 60.

In SQL, we use Comparison operators such as =, !=, >, <, >=, <=,<>, !<, !>. Check the below image for the description of each operator.

SQL Comparison Operators

SQL Logical Operators:

In SQL, we use Logical operators such as AND, OR, NOT, IN, BETWEEN, ALL, EXISTS, LIKE. Check the below image for the description of each operator.

SQL Logical Operators

In the next tutorial, we will see How To Create A Database In SQL

Check out the complete SQL Tutorial by clicking on below link:

SQL Tutorial – Complete

SUBSCRIBE TO GET FREE EBOOK AND REGULAR UPDATES ON SOFTWARE TESTING

Filed Under: SQL

data-matched-content-rows-num="2" data-matched-content-columns-num="3"
Previous Article:
SQL Create Database – SQL TUTORIAL | Software Testing Material
Next Article:
SQL Data Types – SQL Tutorial | Software Testing Material

About the Author

Rajkumar SM is a founder of SoftwareTestingMaterial. He is a certified Software Test Engineer by profession and blogger & youtuber by choice. He has an extensive experience in the field of Software Testing. He writes here about Software Testing which includes both Manual and Automation Testing. He loves to be with his wife and cute little kid 'Freedom'.

ADVERTISEMENT

Froglogic-Squish-GUI-Tester
CrossBrowserTesting

TUTORIALS

  • Manual Testing Tutorial
  • Selenium Tutorial
  • TestNG Tutorial
  • VBScript Tutorial
  • Agile Methodology
  • SQL Tutorial for Testers
  • INTERVIEW QUESTIONS

  • Framework Interview Questions
  • Real Time Manual Testing
  • 100 Top Selenium Interview Questions
  • 30 Top TestNG Interview Questions
  • Agile Interview Questions
  • 80 SQL Interview Questions
  • TESTING TOOLS

  • Test Lodge
  • FrogLogic Squish
  • Cross Browser Testing
  • BrowserStack
  • Test Case Lab
  • Sikuli
  • © 2019 www.softwaretestingmaterial.com | About us | Privacy Policy | Contact us | Guest Post | Disclaimer | Terms of use | Sitemap