Structura generala a unui select Transact-SQL

November 12, 2009


Dupa having sum(coloana_agregata) urmeaza o conditie >10 , =0 etc.

Dupa clauza FROM urmeaza clauza WHERE pt.conditie (dar doar atunci cand nu avem functie agregata in select adica nu avem max,min,avg,sum,count). Sau avem where dupa inner join dk avem si join in cererea respectiva. (dk avem si join-uri in cererea respectiva where-ul vine dupa join apoi urmand group by si dk este cazul order by).

In cazul in care avem functie agregata structura unui select este cea prezentata mai sus.


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 )

Google+ photo

You are commenting using your Google+ 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 )

Connecting to %s

%d bloggers like this: