1 / 9

VW i SQL

VW i SQL. VW i SQL. 1: select navn from lev where lby = 'berlin' 2: select model from bil where fabrik='wolfsburg'. VW i SQL. 3: select distinct lnr from bil,lvb where bil.bnr=lvb.bnr and model='jetta’ 4: select distinct model from bil,lvb where bil.bnr=lvb.bnr and lnr='l1'.

patsy
Télécharger la présentation

VW i SQL

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. VW i SQL NOEA/IT - Databaser/VWiSOL

  2. VW i SQL 1: select navn from lev where lby = 'berlin' 2: select model from bil where fabrik='wolfsburg' NOEA/IT - Databaser/VWiSOL

  3. VW i SQL 3: select distinct lnr from bil,lvb where bil.bnr=lvb.bnr and model='jetta’ 4: select distinct model from bil,lvb where bil.bnr=lvb.bnr and lnr='l1' NOEA/IT - Databaser/VWiSOL

  4. VW i SQL 5: select navn from lev where exists (select * from bil,lvb where bil.bnr=lvb.bnr and lvb.lnr=lev.lnr and model='golf’ and exists (select * from bil,lvb where bil.bnr=lvb.bnr and lvb.lnr=lev.lnr and model='passat')) NOEA/IT - Databaser/VWiSOL

  5. Alternativt – 5b (select navn from lev,lvb,bil where lev.lnr=lvb.lnr and lvb.bnr=bil.bnr and model='passat') intersect (select navn from lev,lvb,bil where lev.lnr=lvb.lnr and lvb.bnr=bil.bnr and model='golf') NOEA/IT - Databaser/VWiSOL

  6. VW i SQL 6: select distinct navn from lev, lvb, vare where betegn = 'møtrik' and lev.lnr=lvb.lnr and lvb.vnr=vare.vnr NOEA/IT - Databaser/VWiSOL

  7. VW i SQL 7: select distinct navn from lev, lvb, bil where fabrik = 'wolfsburg' and lev.lnr=lvb.lnr and lvb.bnr=bil.bnr NOEA/IT - Databaser/VWiSOL

  8. VW i SQL 8: select distinct model from lev, lvb, bil where navn = 'dohrman' and lev.lnr=lvb.lnr and lvb.bnr=bil.bnr NOEA/IT - Databaser/VWiSOL

  9. VW i SQL 9: select distinct vare.vnr,betegn,vaegt from bil,lev,vare,lvb where bil.bnr=lvb.bnr and lev.lnr=lvb.lnr and vare.vnr=lvb.vnr and lby<>fabrik and vaegt>10 NOEA/IT - Databaser/VWiSOL

More Related