SQLShackSkip to content

SQL Not Equal Operator introduction and examples

June 6, 2019 by 

Rajendra Gupta

ApexSQL pricing

This article explores the SQL Not Equal comparison operator (<>) along with its usage scenarios.

Introduction

We must have used comparison operators in mathematics in the early days. We use these operators to compare different values based on the conditions. For example, we might compare the performance of two authors based on a number of articles. Suppose Raj wrote 85 articles while Rajendra wrote 100 articles. We can say that-

The total number of articles written by Rajendra > (Greater than) the total number of articles written by Raj.

We can have the following comparison operators in SQL.

Vous aimerez aussi...