Rabu, 04 Mei 2011

sql Aggregates dan tipe data

SQL AGGREGATES
Examples of Aggregates

 

 
 

Aggregate with GROUP BY


 

    

GROUP BY with two columns

 


  

Combining SELECTs

 

Combining two tables with UNION




 
 
EXCEPT restricts output from the First SELECT


INTERSECT returns only duplicated rows

 
Creation of array columns
 

Large Objects (BLOBs)





Tidak ada komentar:

Posting Komentar