The SQL WHERE Clause is used to filter records. Once you attain the columns that you want, you can filter the data on any column.
The following scenario describes how use WHERE to filter records.
Scenario
You only want to report on Invoices in an Approved or Pending state.
Solution
Use the following WHERE clause at the end of our statement: WHERE inv.STATUS = 'Approved' OR inv.STATUS = 'Pending'
Note: You can add multiple filters using the OR and AND operators.
Legal Notices
Copyright © 2016, 2018,
Oracle and/or its affiliates. All rights reserved.
Last Published Wednesday, March 28, 2018