h1

Cap.13 Subquery-uri

March 24, 2010

1) Exemplu grouped subqueries

2)

3) Predicatele EXISTS si NOT EXIST la subqueries:

4) Relatia intre joins si subqueries

5) Cuvinte rezervate IN si NOT IN la subcereri

6) ALL ,SOME si ANY subquery ce intoarce valori multiple:

7) Folosire functie agregat intr-un subquery pt.a intoarce o singura valoare:

8) Rolul subquery-urilor intr-o clauza where:

9) Subquery-uri pt. a intoarce valoare de true sau false

10) Nested queries pt.a intoarce valoare de true sau false:

11) Queries corelate

12) Subqueries in clauza HAVING

13) Query-uri corelate cu operatori de comparatie

14) Folosire query corelat ca un filtru (clauza HAVING ):

15) Query-uri corelate cu clauza update


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: