Include rows

Use the equal sign (=) relational operator to include rows in a WHERE clause, as the following query shows.

Figure 1. Query

SELECT customer_num, call_code, call_dtime, res_dtime
   FROM cust_calls
   WHERE user_id = 'maryj';

The query returns the set of rows that is shown.

Figure 2. Query result

customer_num  call_code  call_dtime       res_dtime     

         106  D          1998-06-12  08:20 1998-06-12 08:25
         121  O          1998-07-10 14:05 1998-07-10 14:06
         127  I          1998-07-31 14:30