SQL m4 Proiezioni-Selezioni
-
Upload
cinzia-bocchi -
Category
Documents
-
view
219 -
download
0
Transcript of SQL m4 Proiezioni-Selezioni
-
7/30/2019 SQL m4 Proiezioni-Selezioni
1/7
@bojgw` wjb`qlch`bj1 ywcljqlchl j tjbjqlchl
B` n`hlycb`qlchj mjl m`}l hjb ncmjbbc wjb`qlch`bj `vvljhj njml h}j obl cyjw`}cwlmjbb`bojgw` wjb`qlch`bj( Obl cyjw`hml tchc wjb`qlchl %}`gjbbj, j lb wltzb}`}c `hdcw` zh`wjb`qlchj %}`gjbb`,( B` }`gjbb` c}}jhz}` m`bbjtjdzqlchj ml zhcyjw`qlchj mj}}` wjtzb}tj} cwjdcwmtj} wltzb}`h}j jm }jnycw`hj`" dlc hch vljhj njncwlqq`}` hjb m`}`g`tj" ` njhcdej hch vjho` tyjdlfld`}c mlvjwt`njh}j(Obl cyjw`}cwl mjbb`bojgw` wjb`qlch`bj tchc c}}c( Lh pzjt}` mltyjht` hj vjmwjnc }wj1. bcyjw`}cwj ml ywcljqlchj %ywcajd},;. bcyjw`}cwj ml tjbjqlchj %tjbjd},;. bcyjw`}cwj ml wlmjhcnlh`qlchj %wjh`nj,(
]z}}j bj fzhqlch`bl} mjobl cyjw`}cwl wjb`qlch`bl tchc wj`blqq`}j njml`h}j zh zhldc dct}wz}}ctlh}`}}ldc del`n`}c pzjw| %lh}jwwco`qlchj,( Lh TPB }`bj dct}wz}}c w`yywjtjh}`}c dch lbdcn`hmc TJBJD]" lb pz`bj ywjtjh}` mlvjwtj fcwnj ` tjdchm` mjbb` fzhqlch`bl} dej tl
mjtlmjw` c}}jhjwj(
@b flhj ml wjhmjwj yl del`w` b` tyljo`qlchj j fcwhlwj mjobl jtjnyl" tl f`w ztc mjbb`tjozjh}j }`gjbb` ml jtjnylc(
LNYLJO@]C
n`}w dcoh t}lyjhmlc mly`w}lnjh}c
}00
090 Tlbl 69 Hc
}7 097 Wcttl =9 Hc
}4 094 Hjwl =9 Hc
}= 790 Hjwl =9 Tz
}: 797 Vjwml :9 Tz
}6 490 Gltl ?9 Lt
Ywcljqlchj
B` ywcljqlchj dchtjh}j ml tdjobljwj pz`bl dcbchhj mcvw`hhc dcny`wlwj hjb wjtzb}tj}( B`tlh}`ttl m` z}lblqq`wj b` tjozjh}j1
TJBJD] dcbchh`0" (((" dcbchh`HFWCN }`gjbb`
Jtjnylc 01 Vltz`blqq`wj n`}wldcb` j dcohcnj ml cohl lnyljo`}c
TJBJD] n`}w" dcohFWCN lnyljo`}c
0 }0 lhmld` b` }zyb` 0
Gcddel Dlhql`Zb}lnc oolcwh`njh}c1 0:#9
-
7/30/2019 SQL m4 Proiezioni-Selezioni
2/7
Wjtzb}tj}1
n`}w dcoh
}0 090 Tlbl
}7 097 Wcttl
}4 094 Hjwl
}= 790 Hjwl
}: 797 Vjwml
}6 490 Gltl
Jtjnylc 71 Vltz`blqq`wj }z}}l l m`}l ml dl`tdzh lnyljo`}c
Jtlt}j zh` tlh}`ttl yjw lhmld`wj }z}}j bj dcbchhj ml zh` }`gjbb`" tjhq` mcvjwbj tdwlvjwj(
TJBJD] !FWCN lnyljo`}c;
B` ywjdjmjh}j pzjw| jpzlv`bjh}j `
TJBJD] n`}w" dcoh" t}lyjhmlc" mly`w}lnjh}cFWCN lnyljo`}c;
Wjtzb}tj}1 }`gjbb`LNYLJO@]C
Jtjnylc 41 Vltz`blqq`wj }z}}l l dcohcnl mjobl lnyljo`}l
TJBJD] dcohFWCN lnyljo`}c
Wjtzb}tj}1
dcoh
}0 Tlbl
}7 Wcttl
}4 Hjwl
}= Hjwl
}: Vjwml
}6 Gltl
Gcddel Dlhql`Zb}lnc oolcwh`njh}c1 0:#9
-
7/30/2019 SQL m4 Proiezioni-Selezioni
3/7
Jtjnylc =1 Vltz`blqq`wj }z}}l l dcohcnl mjobl lnyljo`}l" tjhq` wlyj}lqlchl
Dcnj tl yz hc}`wj" b` pzjw| mjbbjtjnylc 4 hch jblnlh` l dcohcnl wlyj}z}l( Tj tl mjtlmjw`jblnlh`wj bj wlyj}lqlchl tl mjvj z}lblqq`wj b` db`ztcb` MLT]LHD](
TJBJD] MLT]LHD] dcohFWCN lnyljo`}c
Wjtzb}tj}1
dcoh
}0 Tlbl
}7 Wcttl
}4 Hjwl
}= Vjwml
}: Gltl
Jtjnylc :1 Vltz`blqq`wj obl t}lyjhml mjobl lnyljo`}l `znjh}`}l mjb 7*" lhtljnj `bb`n`}wldcb`
Obl `wocnjh}l mjbb` TJBJD] ycttchc jttjwj dct}l}zl}l `hdej m` jtywjttlchl `wl}nj}ldej(
TJBJD] n`}w" %t}lyjhmlc + t}lyjhmlc ! 7 # 099,
FWCN lnyljo`}c
Wjtzb}tj}1
n`}w t}lyjhmlc
}0 090 60(7
}7 097 =9(5
}4 094 =9(5
}= 790 =9(5
}: 797 :0
}6 490 ?0(=
Wlmjhcnlh`qlchj
B` wlmjhcnlh`qlchj dchtjh}j ml `}wlgzlwj zh hcnj mlvjwtc `bbj dcbchhj mjbb` db`ztcb`TJBJD] j `bbj }`gjbbj mjbb db ztcb` FWCN" z}lblqq`hmc bcyjw }cwj @T( B`wlmjhcnlh`qlchj `vvljhj tyjdlfld`hmc @T" tjozl}c m`b hzcvc hcnj %`bl`t," tzgl}c mcyc b`dcbchh`#}`gjbb`(
Gcddel Dlhql`Zb}lnc oolcwh`njh}c1 0:#9
-
7/30/2019 SQL m4 Proiezioni-Selezioni
4/7
Bcyjw`}cwj ml wlmjhcnlh`qlchj hch ncmlfld` lb hcnj mjbbj dcbchhj hjbb` }`gjbb` cwlolh`bjn` tcbc hjbb` }`gjbb wltzb} h}j; tl }w`}}` pzlhml ml zh` ncmlfld` }jnycw`hj` dej e` dcnjtdcyc lb wjhmjwj n`oolcwnjh}j dcnywjhtlglbl l wltzb}`}l(Yjw pz`h}c wloz`wm` b` ncmlfld` mjb hcnj ml zh` }`gjbb`" bz}lbl} wltljmj hjbb` ycttlglbl} mlwlfjwlwtl `bb` t}jtt` dch zh hcnj tjnyblfld`}c c `ggwjvl`}c(
Jtjnylc 61 Vltz`blqq`wj n`}wldcb` j dcohcnj ml cohl lnyljo`}c d`ngl`hmc l hcnlmjobl `}}wlgz}l wltyj}}lv`njh}j lh n`}wldcb` j dcohcnj
TJBJD] n`}w@T n`}wldcb`" dcoh @T dcohcnjFWCN lnyljo`}c
Wjtzb}tj}1
n`}wldcb` dcohcnj
}0 090 Tlbl
}7 097 Wcttl
}4 094 Hjwl
}= 790 Hjwl
}: 797 Vjwml
}6 490 Gltl
TjbjqlchjB` tjbjqlchj dchtjh}j ml tdjobljwj pz bl wloej mjbb` }`gjbb mcvw`hhc dcny`wlwj hjbwjtzb}tj}( B` tlh}`ttl m` z}lblqq`wj b` tjozjh}j1
TJBJD] dcbchh`0" (((" dcbchh`HFWCN }`gjbb`_EJWJ dchmlqlchj
B` dchmlqlchj ml wldjwd` zhjtywjttlchj dcnyct}` dch cyjw`}cwl `wl}nj}ldl" bcoldl j mldchfwch}c( B` }`gjbb` tjozjh}j wl`ttznj l ywlhdly`bl cyjw`}cwl(
cyjw`}cwl wl}nj}ldl +" ." !" #
cyjw`}cwl bcoldl HC]" @HM" CW
cyjw`}cwl ml dchfwch}c >" 28 %mlvjwtc," 2" 2>" 8" 2>
Jtjnylc ?1 ]wcv`wj obl lnyljo`}l lb dzl t}lyjhmlc tzyjwlcwj ` =9
TJBJD] !FWCN lnyljo`}c_EJWJ t}lyjhmlc 8 =9
Gcddel Dlhql`Zb}lnc oolcwh`njh}c1 0:#9
-
7/30/2019 SQL m4 Proiezioni-Selezioni
5/7
Wjtzb}tj}1
n`}w dcoh t}lyjhmlc mly`w}lnjh}c
}0 090 Tlbl 69 Hc
}7 797 Vjwml :9 Tz
}4 490 Gltl ?9 Lt
Jtjnylc 51 ]wcv`wj obl lnyljo`}l lb dzl t}lyjhmlc dcnywjtc }w` 69 j ?9 %lhdbztl,
TJBJD] !FWCN lnyljo`}c_EJWJ t}lyjhmlc 8> 69 @HM t}lyjhmlc 2> ?9
Wjtzb}tj}1
n`}w dcoh t}lyjhmlc mly`w}lnjh}c
}0 090 Tlbl 69 Hc
}7 490 Gltl ?9 Lt
Zh` dchmlqlchj jpzlv bjh}j `bb` ywjdjmjh}j jtywlnlglbj njml h}j bcyjw }cwjGJ]_JJH(
TJBJD] !FWCN lnyljo`}c_EJWJ t}lyjhmlc GJ]_JJH =9 @HM ?9
Jtjnylc 79 CW t}lyjhmlc 8> =9
Wjtzb}tj}1
n`}w dcoh t}lyjhmlc mly`w}lnjh}c
}0 090 Tlbl 69 Hc
}7 797 Vjwml :9 Tz
}4 490 Gltl ?9 Lt
Gcddel Dlhql`Zb}lnc oolcwh`njh}c1 0:#9
-
7/30/2019 SQL m4 Proiezioni-Selezioni
6/7
Jtjnylc 091 ]wcv`wj obl lnyljo`}l lb dzl t}lyjhmlc hch dcnywjtc }w` =9 j ?9%lhdbztl,
TJBJD] !FWCN lnyljo`}c
_EJWJ HC] %t}lyjhmlc 8> =9 @HM t}lyjhmlc 2> ?9,
cyyzwj" h`bco`njh}j
TJBJD] !FWCN lnyljo`}c_EJWJ HC] %t}lyjhmlc GJ]_JJH =9 @HM ?9,
TJBJD] !FWCN lnyljo`}c
_EJWJ t}lyjhmlc 2 =9 CW t}lyjhmlc 8 ?9
Wjtzb}tj}1 }`gjbb` vzc}`
Jtjnylc 001 ]wcv`wj obl lnyljo`}l mjb mly`w}lnjh}c Tz c Lt
TJBJD] !FWCN lnyljo`}c_EJWJ mly`w}lnjh}c > Tz CW mly`w}lnjh}c > Lt
Zh` dchmlqlchj jpzlv`bjh}j `bb` ywjdjmjh}j jtywlnlglbj njml`h}j bcyjw`}cwj LH(
TJBJD] !FWCN lnyljo`}c_EJWJ mly`w}lnjh}c LH % Tz" Lt,
cyyzwj" h`bco`njh}j
TJBJD] !FWCN lnyljo`}c_EJWJ mly`w}lnjh}c HC]LH % Hc,
c" `hdcw`
TJBJD] !FWCN lnyljo`}c_EJWJ mly`w}lnjh}c 28 Hc
Gcddel Dlhql`Zb}lnc oolcwh`njh}c1 0:#9
-
7/30/2019 SQL m4 Proiezioni-Selezioni
7/7
Wjtzb}tj}1
n`}w dcoh t}lyjhmlc mly`w}lnjh}c
}0 790 Hjwl =9 Tz
}7 797 Vjwml :9 Tz
}4 490 Gltl ?9 Lt
Jtjnylc 071 ]wcv`wj obl lnyljo`}l lb dzl dcohcnj lhlql` dch W
Bcyjw`}cwj BLKJ dchtjh}j ml jffj}}z`wj wldjwdej tz y`w}l ml t}wlhoej( Z}lblqq`" ` }`b tdcyc"mzj d`w`}}jwl acbb|1 * j S(Lb d`w`}}jwj * lhmld` zh lhtljnj ml d`w`}}jwl pz`bzhpzj" njh}wj lb d`w`}}jwj S lhmld` zhd`w`}}jwj pz`bzhpzj(
TJBJD] !FWCN lnyljo`}c_EJWJ dcoh BLKJ W*
Wjtzb}tj}1
n`}w dcoh t}lyjhmlc mly`w}lnjh}c
}0 097 Wcttl =9 Hc
Pzjt}/cyjw t}`}` wlb`tdl`} dch bldjhq` Dwj }lvj Dcnncht @}}wlgz}lch.Te`wj@blkj 4(9 Zhycw}jm( Yjwbjoojwj zh` dcyl` mjbb` bldjhq` vltl}` lb tl}c jg e}}y1##dwj`}lvjdcnncht(cwo#bldjhtjt#g|.t`#4(9# c tyjmltdlzh` bj}}jw` ` Dwj`}lvj Dcnncht" 0?0 Tjdchm T}wjj}" Tzl}j 499" T`h Fw`hdltdc" D`blfcwhl`"