正在加载图片...
Example Queries Find the ID,name,dept_name,salary for instructors whose salary is greater than $80,000 {t|t e instructor^t[salary ]>80000) Notice that a relation on schema(ID,name,dept_name,salary)is implicitly defined by the query As in the previous query,but output only the /D attribute value t3s e instructor(t [ID ]=s [ID ]s [salary ]>80000)} Notice that a relation on schema(/D)is implicitly defined by the query Database System Concepts-6th Edition 6.15 @Silberschatz,Korth and SudarshanDatabase System Concepts - 6 6.15 ©Silberschatz, Korth and Sudarshan th Edition Example Queries Find the ID, name, dept_name, salary for instructors whose salary is greater than $80,000 As in the previous query, but output only the ID attribute value {t |  s  instructor (t [ID ] = s [ID ]  s [salary ]  80000)} {t | t  instructor  t [salary ]  80000} Notice that a relation on schema (ID) is implicitly defined by the query Notice that a relation on schema (ID, name, dept_name, salary) is implicitly defined by the query
<<向上翻页向下翻页>>
©2008-现在 cucdc.com 高等教育资讯网 版权所有