正在加载图片...
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 einstructor (t [ID ]=s [ID ]^s [salary ]>80000)) Notice that a relation on schema(/D)is implicitly defined by the query Database System Concepts-7th Edition 27.6 ©Silberscha乜,Korth and SudarshanDatabase System Concepts - 7 27.6 ©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 高等教育资讯网 版权所有