New

The executive guide to generative AI

Read more
About usPartnersSupport|Login
IMPORTANT: No additional bug fixes or documentation updates will be released for this version. For the latest information, see the current release documentation.
« Functions and Operators Logical Operators »
Elastic Docs ›Elasticsearch Guide [6.3] ›SQL Access ›Functions and Operators

Comparison Operators

edit
IMPORTANT: This documentation is no longer updated. Refer to Elastic's version policy and the latest documentation.

Comparison Operators

edit

Elasticsearch SQL supports the following comparison operators:

  • Equality (=) 
SELECT last_name l FROM "test_emp" WHERE emp_no = 10000 LIMIT 5;
  • Inequality (<> or != or <=>) 
SELECT last_name l FROM "test_emp" WHERE emp_no <> 10000 ORDER BY emp_no LIMIT 5;
  • Comparison (<, <=, >, >=) 
SELECT last_name l FROM "test_emp" WHERE emp_no < 10003 ORDER BY emp_no LIMIT 5;
  • BETWEEN 
SELECT last_name l FROM "test_emp" WHERE emp_no BETWEEN 9990 AND 10003 ORDER BY emp_no;
  • IS NULL/IS NOT NULL 
SELECT last_name l FROM "test_emp" WHERE emp_no IS NOT NULL AND gender IS NULL;
« Functions and Operators Logical Operators »
Was this helpful?
Feedback