SQL where clause

The SQL WHERE clause is used to specify a condition while fetching the data from a single table or by joining with multiple tables. If the given condition is satisfied, then only it returns a specific value from the table. The WHERE clause is used to filter records.

The WHERE clause can be used in the SELECT statement, the UPDATE, DELETE statement, etc.,. A
condition can be specified using the comparison or logical operators.

The basic syntax of the SELECT statement with the WHERE clause is as shown below.

SELECT column1, column2, columnN

FROM table_name

WHERE [condition];

Example:

Consider the CUSTOMERS table having the following records 

To fetch ID, Name and Salary fields from the CUSTOMERS table, where the salary is greater than 2000 the query is:

SQL> SELECT ID, NAME, SALARY FROM CUSTOMERS WHERE SALARY > 2000;

Output: