﻿---
title: Logical operators
description: Boolean operator for evaluating one or two expressions. 
url: https://www.elastic.co/elastic/docs-builder/docs/2964/reference/query-languages/sql/sql-operators-logical
products:
  - Elasticsearch
---

# Logical operators
Boolean operator for evaluating one or two expressions.

## `AND`

```sql
SELECT last_name l FROM "test_emp" WHERE emp_no > 10000 AND emp_no < 10005 ORDER BY emp_no LIMIT 5;
```


## `OR`

```sql
SELECT last_name l FROM "test_emp" WHERE emp_no < 10003 OR emp_no = 10005 ORDER BY emp_no LIMIT 5;
```


## `NOT`

```sql
SELECT last_name l FROM "test_emp" WHERE NOT emp_no = 10000 LIMIT 5;
```