正在加载图片...
SQL Queries Principal form: SELECT desired attributes FROM tuple variables-range over relations WHERE condition about tuple variables; Running example relation schema: Beers(name,manf) Bars (name,addr,license) Drinkers(name,addr,phone) Likes (drinker,beer) Sells (bar,beer,price) Frequents(drinker,bar)SQL Queries z Principal form: SE L E C T desired attributes FROM t uple variables –– range over relations W HER E condition about tuple variables; Running example relation schema: B eers ( n am e , m anf) Ba r s ( na m e , addr, lic ense ) D rinker s ( na m e , a d dr, phon e ) Li kes( drink er,be er) S ells(b ar,be er, price ) F requ e nt s ( drinker, b ar)
<<向上翻页向下翻页>>
©2008-现在 cucdc.com 高等教育资讯网 版权所有