The less than operator (<) compares two values and returns TRUE when the value on the left is smaller than the value on the right. It is commonly used with numeric values, dates, and other comparable data.
Many business rules require identifying records below a threshold, such as low-value transactions, employees below a salary limit, or products with low stock.
A company wants to find employees whose salary is below ₹50,000. The less than operator can be used to retrieve those records.
SELECT
EmployeeName,
Salary
FROM Employees
WHERE Salary < 50000;Less than conditions are useful for salary analysis, inventory monitoring, transaction analysis, pricing analysis, and business threshold checks.
- < means less than.
- It compares two values.
- It is commonly used with numeric data.
- It can be used with dates.
- It is useful for identifying values below a threshold.
What does < mean in SQL?
The < operator returns records where the left-side value is less than the right-side value.
Give one business use of the less than operator.
It can be used to identify employees whose salary is below a specified threshold.