Hi, I have this: +----+-------+--------+ � Jahr � Name � Budget � +----+-------+--------+ 2003 Hans 2000 2003 Fritz 5000 2004 Hans 1500 2005 Pia 3500
How is it possible to make this in sql?
+---------------------+ � 2003 Hans 2000 � � 2003 Fritz 5000 � +---------------------+ � Total 7000 � +---------------------+
+---------------------+ � 2004 Hans 1500 � +---------------------+ � Total 1500 � +---------------------+
+---------------------+ � 2005 Pia 3500 � +---------------------+ � Total 3500 � +---------------------+
Thanks a lot, Glenn
Looks like you want separate results for each year present in your table. You can:
- Run a separate query for each year or - Run a single query from within a programming language that allows you to postprocess the results and display separate output for each year
-- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certification/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
