Beginner

355. Less Than Operator

Learn how to filter values that are less than a specified value.

📘 Lesson 355 of 728 ⏱ 8 min 🎯 Beginner

The less-than operator (<) returns true when the value on the left is smaller than the value on the right.

Less-than conditions help analysts identify values below business thresholds.

Find products priced below ₹1,000.

SQL 
SELECT
    ProductName,
    Price
FROM Products
WHERE Price < 1000;

It is useful for pricing analysis, low-value transaction detection, inventory checks, and performance monitoring.

  • The operator is <.
  • It returns values below the comparison value.
  • It can compare numbers and other ordered values.
  • It is commonly used with WHERE.
  • It can be combined with other conditions.
What does < mean in SQL?

It checks whether the left expression is less than the right expression.

How can < be used in business analysis?

It can identify products below a price threshold or transactions below a specified amount.

Have you finished this lesson?

Introduction to SQL – All Lessons