h1

Cap23. Interogari si sub-interogari avansate,tabele temporare,intersectia a 2 tabele, diferenta a 2 tabele

March 28, 2010

1) Self join (multy-query table that refers to itself):

2) Tabele temporare pt. inlaturarea datelor duplicate

Stergere inregistrari din tabela temporara:

3) Setare valori tabela 1 bazat pe valori din tabela 2 (clauza UPDATE):

4) Operatorii IN si EXISTS (IN verifica daca o valoare e intr-o lista de valori)

5) Operatorul ALL pt.a combina 2 query-uri intr-una singura

6) Operatorul EXISTS pt.a verifica daca exista inregistrari duplicat in tabela

7) Join la continutul tabelelor si rezultatele functiilor (chestionar msssql)

8) Folosire view-uri pt.a vedea ierarhia  nivelurilor de agregare

9) Predicatul EXISTS pt. a afisa intersectia a 2 tabele

10) Predicatul EXCEPT pt.a afisa diferenta dintre 2 tabele

11) Clauza TOP

12) SELECT cu RUNNING TOTALS

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: