home *** CD-ROM | disk | FTP | other *** search
/ ProfitPress Mega CDROM2 …eeware (MSDOS)(1992)(Eng) / ProfitPress-MegaCDROM2.B6I / MAGAZINE / MISC / DBMS9103.ZIP / 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;