Beginner

168. Greater Than Operator

Learn how the greater-than operator filters values above a specified value.

📘 Lesson 168 of 728 ⏱ 7 min 🎯 Beginner

The greater-than operator (>) returns rows where one expression has a value greater than another expression.

Threshold-based analysis is common in business reporting, such as identifying high-value sales or employees above a salary level.

Find employees earning more than ₹75,000.

SQL 
SELECT
    EmployeeName,
    Salary
FROM Employees
WHERE Salary > 75000;

The operator is useful for salary analysis, sales thresholds, transaction monitoring, financial limits, and performance metrics.

  • > means greater than.
  • It is commonly used with numeric values.
  • It can also compare dates and other ordered values.
  • It excludes values equal to the threshold.
  • It is useful for threshold analysis.
What does > mean in SQL?

It returns values that are greater than the specified comparison value.

Does Salary > 75000 include 75000?

No. Greater than excludes the value that is exactly equal to 75000.

Have you finished this lesson?

Introduction to SQL – All Lessons