Hi,
I want report like this
Table description is like as follows
Field | Type | Null | Key | Default |
Extra |
+-------------------------+------------------+------+-----+---------------------+----------------+
| id | int(10) unsigned | | PRI | NULL
| auto_increment |
| host_id | int(10) unsigned | | MUL | 0
| |
| time | datetime | | MUL | 0000-00-00 00:00:00
| |
| process | int(10) unsigned | | | 0 |
|
| pending | int(10) unsigned | | | 0 |
|
| wip | int(10) unsigned | | | 0 |
|
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 ?
thanks
-Seena
---------------------------------
Yahoo! Mail Mobile
Take Yahoo! Mail with you! Check email on your mobile phone.
