TD n°4 SQL (9-16)
米罗家的药箱 · 鸵鸟 · 2004-10-07
一只世上最幸福的药箱。里面装着世上最幸福的药片。
|
主页
|
TD n°4 SQL (18-20)>>>
TD n°4 SQL (9-16)
2004-10-07
9.
SELECT *
FROM R8
WHERE nomecr Like "*A*";
10.
SELECT prixvente/1.155 AS prixht
FROM tarifer;
11.
SELECT count(numecr)
FROM ecrivain
WHERE languecr="Anglais"
OR languecr="Allemand";
12.
SELECT sum(qtestock)
FROM classification, ouvrage, stocker, depot
WHERE classification.numrub=ouvrage.numrub
AND ouvrage.numouvr=stocker.numouvr
AND stocker.numdep=depot.numdep
AND librub="gestion de portefeuilles"
AND villedep="Grenoble";
13.
SELECT nomouvr
FROM R1, ouvrage, tarifer
WHERE ouvrage.numouvr=tarifer.numouvr
AND tarifer.prixvente=R1.maxprix;
14.
SELECT nomecr, prenomecr, count(numouvr)
FROM ecrivain, ecrire
WHERE ecrivain.numecr=ecrire.numecr
GROUP BY nomecr, prenomecr;
15.
SELECT librub, Sum(qtestock) AS nombresto
FROM classification, stocker, depot, ouvrage
WHERE classification.numrub=ouvrage.numrub
AND ouvrage.numouvr=stocker.numouvr
AND stocker.numdep=depot.numdep
AND depot.villedep="Grenoble"
GROUP BY librub;
16.
SELECT librub,
iif
(nombresto>1000, "élevé", "faible")
FROM R15;
鸵鸟
引用(Trackback0)
发表评论
最近更新
TD n°4 SQL (18-20)
TD n°4 SQL (9-16)
TD n°4 SQL (1-8)
Tristan et Iseult(2)
Tristan et Iseult(1)
日片(17)
日片(16)
日片(15)
日片(14)
小王子(6)
原始快照:web.archive.org