正在加载图片...
Example Queries Find the loan number,branch name,and amount for loans of over $1200 {t tE loan ^t [amount ]1200) Find the loan number for each loan of an amount greater than $1200 {t |3s e loan (t [loan_number ]s [loan_number ]^s [amount ]>1200)} Notice that a relation on schema [loan number is implicitly defined by the query Database System Concepts-5th Edition,July 8,2005 5.6 ©Silberschat乜,Korth and SudarshanDatabase System Concepts - 5 5.6 ©Silberschatz, Korth and Sudarshan th Edition, July 8, 2005 Example Queries Find the loan_number, branch_name, and amount for loans of over $1200 Find the loan number for each loan of an amount greater than $1200 {t |  s  loan (t [loan_number ] = s [loan_number ]  s [amount ]  1200)} Notice that a relation on schema [loan_number ] is implicitly defined by the query {t | t  loan  t [amount ]  1200}
<<向上翻页向下翻页>>
©2008-现在 cucdc.com 高等教育资讯网 版权所有