The select Clause(Cont.) An asterisk in the select clause denotes "all attributes" select from loan The select clause can contain arithmetic expressions involving the operation,+-*and /and operating on constants or attributes of tuples. The query: select loan number,branch name,amount 100 from loan would return a relation that is the same as the loan relation,except that the value of the attribute amount is multiplied by 100 Database System Concepts,5th Edition,Oct 5,2006 3.12 Silberschatz,Korth and SudarshanDatabase System Concepts, 5 3.12 ©Silberschatz, Korth and Sudarshan th Edition, Oct 5, 2006 The select Clause (Cont.) An asterisk in the select clause denotes “all attributes” select * from loan The select clause can contain arithmetic expressions involving the operation, +, –, , and /, and operating on constants or attributes of tuples. The query: select loan_number, branch_name, amount  100 from loan would return a relation that is the same as the loan relation, except that the value of the attribute amount is multiplied by 100