The where Clause The where clause specifies conditions that the result must satisfy corresponds to the selection predicate of the relational algebra To find all loan number for loans made at the Perryridge branch with loan amounts greater than $1200 select / oan-number from loan where branch-name Perryridge and amount>1200 Comparison results can be combined using the logical connectives and. or and not Database System Concepts 4.7 OSilberschatz. Korth and SudarshanDatabase System Concepts 4.7 ©Silberschatz, Korth and Sudarshan The where Clause The where clause specifies conditions that the result must satisfy corresponds to the selection predicate of the relational algebra. To find all loan number for loans made at the Perryridge branch with loan amounts greater than $1200. select loan-number from loan where branch-name = ‘Perryridge’ and amount > 1200 Comparison results can be combined using the logical connectives and, or, and not