# IF

If the first argument is true, returns second argument. If the first argument is false or NULL, returns third argument.

## Syntax

```sql
IF(condition, value_if_true, value_if_false)

```

## Arguments

* Any SQL objects

## Return Type

Returns a value based on a specified condition.

## Examples

Create a table and insert values:

```sql
CREATE TABLE orders(comp_id INT(10), comp_name VARCHAR(50), 
  order_number INT(10), order_total INT(10));

INSERT INTO orders VALUES("64","Wolf-Conn","4722","9"),
("924","Blick, Von and Lynch","9610","52"),
("487","Sipes-Bauch","5180","14"),
("835","Shields-Kiehn","7961","684"),
("476","Bogisich, Brown and Hessel","4687","482"),
("809","Cole-Durgan","9358","467"),
("232","Towne LLC","3774","445");
```

Create a query using the `IF` function:

```sql
SELECT order_number,
       comp_id,
       order_total,
       IF(order_total > 100, 'Yes', 'No') AS amount_greater_than_100
FROM orders;


```

```output

+--------------+---------+-------------+-------------------------+
| order_number | comp_id | order_total | amount_greater_than_100 |
+--------------+---------+-------------+-------------------------+
|         4687 |     476 |         482 | Yes                     |
|         9358 |     809 |         467 | Yes                     |
|         5180 |     487 |          14 | No                      |
|         3774 |     232 |         445 | Yes                     |
|         7961 |     835 |         684 | Yes                     |
|         4722 |      64 |           9 | No                      |
|         9610 |     924 |          52 | No                      |
+--------------+---------+-------------+-------------------------+

```

***

Modified at: March 13, 2024

Source: [/db/v9.1/reference/sql-reference/conditional-functions/if/](https://docs.singlestore.com/db/v9.1/reference/sql-reference/conditional-functions/if/)

(An index of the documentation is available at /llms.txt)