Connecting Conditions with Logical Operators
AND joins two or more conditions and returns results only when all of the conditions are true. For example, the following query will find only the rows in which the author's last name is Ringer and the author's first name is Anne. It will not find the row for Albert Ringer.SQL
select au_id, au_lname, au_fname from authors where au_lname = 'Ringer' and au_fname = 'Anne' au_id au_lname au_fname =========== =================================== ======== 899-46-2035 Ringer Anne [1 row]
The next example finds business books with a price ...