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. Comparisons can be applied to results of arithmetic expressions. Database System Concepts,5th Edition,Oct 5,2006 3.13 Silberschatz,Korth and SudarshanDatabase System Concepts, 5 3.13 ©Silberschatz, Korth and Sudarshan th Edition, Oct 5, 2006 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. Comparisons can be applied to results of arithmetic expressions