Not Equal To In SQL

Galaxy Glossary

How do you compare values to ensure they are not equal in SQL?

The `!=` or `<>` operator in SQL is used to check if two values are not equal. It's a fundamental comparison operator used in `WHERE` clauses to filter data based on inequality.

Sign up for the latest in SQL knowledge from the Galaxy Team!
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.

Description

The `!=` (not equal to) or `<>` (not equal to) operator in SQL is a crucial part of data filtering. It allows you to select rows where a specific column's value doesn't match a given value. This operator is essential for querying databases and retrieving only the data you need. For instance, if you want to find all customers who haven't placed an order in the last month, you'd use `!=` or `<>` to compare the order date to a specific date. This operator is often used in conjunction with other comparison operators like `>`, `<`, `>=`, and `<=` to create complex filtering conditions. It's a fundamental building block for constructing queries that extract specific subsets of data from a database table. The choice between `!=` and `<>` is largely a matter of personal preference or database system convention; both achieve the same result.

Why Not Equal To In SQL is important

The `!=` or `<>` operator is critical for filtering data. It allows developers to extract specific subsets of data from a database, which is essential for reporting, analysis, and decision-making. Without this operator, you'd be limited in your ability to isolate and examine particular data points.

Not Equal To In SQL Example Usage


-- Sample table: Customers
CREATE TABLE Customers (
    CustomerID INT PRIMARY KEY,
    FirstName VARCHAR(50),
    LastName VARCHAR(50),
    City VARCHAR(50)
);

INSERT INTO Customers (CustomerID, FirstName, LastName, City) VALUES
(1, 'John', 'Doe', 'New York'),
(2, 'Jane', 'Smith', 'Los Angeles'),
(3, 'Peter', 'Jones', 'Chicago'),
(4, 'David', 'Brown', 'New York');

-- Query to find customers who do not live in New York
SELECT FirstName, LastName, City
FROM Customers
WHERE City != 'New York';

Common Mistakes

Want to learn about other SQL terms?

With Cte In SQL

Common Table Expressions (CTEs) are temporary, named result sets defined within a single SQL statement. They enhance query readability and reusability by breaking down complex queries into smaller, manageable parts.

Where Vs Having SQL

WHERE and HAVING are both used for filtering data in SQL, but they operate on different levels. WHERE filters rows before any aggregation, while HAVING filters groups after aggregation.

Windows Functions In SQL

Window functions in SQL perform calculations over a set of rows related to the current row, unlike aggregate functions which summarize data across all rows. They are powerful tools for analyzing data within a specific context.

Company
BlogFeaturesPricingAboutFeature Requests
Resources
DocsSupportSecurity
Explore
Product TourData Job BoardRecruitersConsultantsStartup ToolsMemes
Learn
Learn SQLBeginner ResourcesData ToolsSQL Interview PrepCommon ErrorsSQL OptimizationSQL In Other LanguagesGlossary
Comparisons
DatagripTablePlusDBeaverBeekeeper StudiopgAdminPosticoCursor
HexBrieferPopSQLSherloqBlazeSQLSweep AIWaii AIOuterbase
© 2025 Galaxy Software Inc.
hello@getgalaxy.io
Reddit IconProduct Hunt IconTwitter / X IconLinkedIn Icon