# Clauses

Here are SQL examples for each clause for filtering data:

**DISTINCT** - remove duplicates

```sql
SELECT DISTINCT column_name FROM table_name;
```

**LIMIT** - constrain number of rows

```sql
SELECT * FROM table_name LIMIT 10;
```

**OFFSET** - skip number of rows

```sql
SELECT * FROM table_name OFFSET 5; 
```

**WHERE** - filter on conditions

```sql
SELECT * FROM table_name WHERE condition;
```

**Comparison Operators**

```sql
SELECT * FROM table_name WHERE column_name > 100; 
```

**Logical Operators - AND**

```sql
SELECT * FROM table_name WHERE column1 = 'value' AND column2 = 'value';
```

**Logical Operators - OR**

```sql
SELECT * FROM table_name WHERE column1 = 'value' OR column2 = 'value';
```

**BETWEEN** - filter between range

```sql
SELECT * FROM table_name WHERE column BETWEEN 10 AND 20;
```

**IN** - check if value is in list

```sql
SELECT * FROM table_name WHERE column IN (value1, value2);
```

**LIKE** - pattern matching

```sql
SELECT * FROM table_name WHERE column LIKE 'pattern%';
```

**IS NULL** - check for NULL values

```sql
SELECT * FROM table_name WHERE column IS NULL;
```

**NOT** - negate Boolean expression

```sql
SELECT * FROM table_name WHERE NOT condition;
```