home *** CD-ROM | disk | FTP | other *** search
/ Black Box 4 / BlackBox.cdr / proglang / dbms9103.arj / SQL5.MAR < prev    next >
Encoding:
Text File  |  1991-01-22  |  126 b   |  2 lines
  1.  
  2. CREATE VIEW city_hist (city, yr, total_sales) AS  SELECT city, YEAR(date), SUM(price*qty) FROM whole_db   GROUP BY 1, 2;