h1

SQL Alias si COUNT functie agregat

November 2, 2009

Sunt nume sugestive date tabelelor sau unor calcule si sunt insotite de cuvantul rezervat AS.

Exemple:

count

Functia COUNT este functie agregat si este insotita de clauza GROUP BY (pt.campurile non-agregat). GROUP BY nume (pt.fiecare nume unic)

GROUP BY se pune dupa WHERE si dupa group by folosim clauza ORDER BY.
GROUP BY se pune dupa inner join.

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: