In article <[EMAIL PROTECTED]>, Seena Blace <[EMAIL PROTECTED]> writes:
> Hi, > I want report like this > date process pending wip > 5/10/05 10 30 40 > 5/11/05 09 28 60 > ------------------------------------------------------------ > Summary 19 58 100 > select date,sum(process),sum(pending),sum(wip) from tab > group by date; > What command I used to show heading and what command to show sub total and > total ? The last row can be calculated by the ROLLUP modifier of GROUP (requires MySQL 4.1.1 or later). Nicely formatting the output with headings etc is not the business of a database engine and should be done by your application. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
