Tag Archives: group by

SQL GROUP BY örnekleri

Materilized View CREATE MATERIALIZED VIEW sales_mv ASSELECTchannel_desc channel,prod_category category,prod_subcategory subcategory,prod_name product,calendar_year year,calendar_quarter_number quarter,calendar_month_number month,SUM(amount_sold) salesFROM sales, times, products, channelsWHERE sales.time_id = times.time_idAND sales.prod_id = products.prod_idAND sales.channel_id = channels.channel_idAND prod_category IN (‘Photo’, ‘Hardware’)AND calendar_year IN (2000, 2001)AND channel_desc IN (‘Direct Sales’, … Continue reading

| Tagged | Leave a comment