The select Clause The select clause list the attributes desired in the result of a query corresponds to the projection operation of the relational algebra Example:find the names of all branches in the /oan relation: select branch name from loan In the relational algebra,the query would be: Ibranch_name(loan) NOTE:SQL names are case insensitive(i.e.,you may use upper-or lower-case letters.) E.g.Branch Name BRANCH NAME branch name Some people use upper case wherever we use bold font. Database System Concepts,5th Edition,Oct 5,2006 3.10 Silberschatz,Korth and SudarshanDatabase System Concepts, 5 3.10 ©Silberschatz, Korth and Sudarshan th Edition, Oct 5, 2006 The select Clause The select clause list the attributes desired in the result of a query corresponds to the projection operation of the relational algebra Example: find the names of all branches in the loan relation: select branch_name from loan In the relational algebra, the query would be: branch_name (loan) NOTE: SQL names are case insensitive (i.e., you may use upper- or lower-case letters.) E.g. Branch_Name ≡ BRANCH_NAME ≡ branch_name Some people use upper case wherever we use bold font