</fc>
<code sql>
select * from BigAnnuaireSimple
where ...
</code>
<code sql>
select * from BigAnnuaire
where ...
</code>
Voici les requêtes utilisées dans les... e ^
| R1 |<code sql>select * from ...; -- sans WHERE </code>| non | non | non |
| AgeEgal |<code sql>... where age = 18;</code> | | | |
| AgeInf
select a.nom, a.prenom
from BigAnnuaire a
where a.age = 18;
@p3
</code>
<showif isloggedin>
... select a.nom, a.prenom
from BigAnnuaire a
where a.age between 20 and 29;
@p3
</code>
<showi... select a.nom, a.prenom
from BigAnnuaire a
where a.age < 70 and (a.cp = 93000 or a.cp = 75000);
@p... select a.nom, a.prenom
from BigAnnuaire a
where a.age = 20 and a.cp = 13000 and a.nom like 'T%';
select a.nom, a.prenom
from BigAnnuaire a
where a.age = 18;
@p3
</code>
<showif isloggedin>
... select a.nom, a.prenom
from BigAnnuaire a
where a.age between 20 and 29;
@p3
</code>
<showi... select a.nom, a.prenom
from BigAnnuaire a
where a.age < 70 and (a.cp = 93000 or a.cp = 75000);
@p... select a.nom, a.prenom
from BigAnnuaire a
where a.age = 20 and a.cp = 13000 and a.nom like 'T%';
select a.nom, a.prenom
from BigAnnuaire a
where a.age = 18;
@p3
</code>
<showif isloggedin>
... select a.nom, a.prenom
from BigAnnuaire a
where a.age between 20 and 29;
@p3
</code>
<showi... select a.nom, a.prenom
from BigAnnuaire a
where a.age < 70 and (a.cp = 93000 or a.cp = 75000);
@p... select a.nom, a.prenom
from BigAnnuaire a
where a.age = 20 and a.cp = 13000 and a.nom like 'T%';
de spécifier les nœuds à retourner et une clause where qui exprime la condition devant être vérifiée.
U... à retourner (projection).
Par exemple, select ?x where {?x joue ?y } retourne les liaisons ?x->james et ... e s'écrit ainsi avec une opération de sélection ''where'', un renommage ''withColumnRenamed'' et une projection ''select'' :
<code scala>
val r1 = yago.where("prop = '<hasCapital>' and objet = '<Nantes>'").
lite, blocks as nb_pages
from all_tables
where table_name='BIGJOUEUR';
</code>
On veut calculer... select J.licence, C.nom
from J, C
where J.cnum = C.cnum
and J.salaire > 1000;
@... select J.licence, C.nom
from J, C
where J.cnum = C.cnum
and J.salaire < 11000;
... sql>
select /*+ ordered */ *
from C, BigJoueur j
where j.cnum = c.cnum;
</code>
<code sql>
select /*+ o
lite, blocks as nb_pages
from all_tables
where table_name='BIGJOUEUR';
</code>
On veut calculer... select J.licence, C.nom
from J, C
where J.cnum = C.cnum
and J.salaire > 1000;
@... select J.licence, C.nom
from J, C
where J.cnum = C.cnum
and J.salaire < 11000;
... sql>
select /*+ ordered */ *
from C, BigJoueur j
where j.cnum = c.cnum;
</code>
<code sql>
select /*+ o
e sql>
select J.licence, C.nom
from J, C
where J.cnum = C.cnum
and J.salaire > 10;
</code>
E... /*+ ordered */ J.licence, C.nom
FROM J, C
where J.cnum = C.cnum
and J.salaire > 10;
</code>
<... /*+ ordered */ J.licence, C.nom
FROM C, J
where J.cnum = C.cnum
and J.salaire > 10;
</code>
b... sql>
select /*+ ordered */ *
from C, BigJoueur j
where j.cnum = c.cnum;
</code>
<code sql>
select /*+ o
select J.licence, C.nom
from J, C
where J.cnum = C.cnum
and J.salaire > 1000;
@... select J.licence, C.nom
from J, C
where J.cnum = C.cnum
and J.salaire < 11000;
... select J.licence, C.division
from C, J
where J.cnum = C.cnum
and C.nom in ('PSG', 'Barca')... for
select J.licence, C.division
from C, J
where J.cnum = C.cnum
and J.salaire between 10000 and
erson {name: 'Jim', age: 47})
2. MATCH (n:Person) WHERE n.name='Jim' RETURN n
3. MATCH (n:Person {name: 'Jim'}) DETACH DELETE n
4. MATCH (n:Person) WHERE n.name='Jim' RETURN n
5. MATCH (n)
WHERE NOT (EXISTS(n.emploi))
SET n.emploi=n.job
REMOVE n.jo... CH (sally:Employee)-[:PARTICIPATES]->(project)
WHERE sally.name="Sally" AND project.town ="Paris"
l>
SELECT DISTINCT productId
FROM reviews
where rating = 5
</code>
</showif>
4. Les identifiants... stomerId, emailAddress
FROM customer
WHERE emailAddress LIKE '%herman.com'
</code>
</showif>... T distinct customerId
FROM purchases
WHERE ARRAY_LENGTH(lineItems) = 5
</code>
</showif> ... T distinct customerId
FROM purchases
WHERE ANY item IN purchases.lineItems SATISFIES item.co