Beginner

354. Greater Than Operator

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

📘 Lesson 354 of 728 ⏱ 8 min 🎯 Beginner

The greater-than operator (>) returns true when the value on the left is greater than the value on the right.

Greater-than comparisons are frequently used to identify high-value transactions, salaries, scores, dates, and performance measures.

Find employees earning more than ₹75,000.

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

It is used for salary analysis, sales thresholds, transaction monitoring, risk analysis, and KPI reporting.

  • The operator is >.
  • It returns values greater than the comparison value.
  • It works with numeric and comparable values.
  • It is commonly used in WHERE.
  • It can be combined with AND and OR.
What does > mean in SQL?

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

Give one business use of >.

It can identify transactions above a specified amount or employees above a salary threshold.

Have you finished this lesson?

Introduction to SQL – All Lessons