Thread View: cn.comp.database.mysql
1 messages
1 total messages
Started by MichaelSun
Fri, 26 Nov 2004 10:14
��̣��������ͳ�Ƶ�sql�����ôд��лл��
Author: MichaelSun
Date: Fri, 26 Nov 2004 10:14
Date: Fri, 26 Nov 2004 10:14
11 lines
1449 bytes
1449 bytes
��ṹΪ�� execute_date date
items varchar(30)
costs int
��ͳ��ÿ�ա�ÿ����Ŀ�����룺
��д���ǣ�select execute_date, item, sum(costs)
FROM item
group by execute_date, item
order by execute_date
��ʾ�Ľ��ͬһ��Ļͣ�ͬһ����Ŀ���ֳ������У���֪��ʲôԭ�������ʹ��
ÿ��ֻ��һ�У�
лл��
Thread Navigation
This is a paginated view of messages in the thread with full content displayed inline.
Messages are displayed in chronological order, with the original post highlighted in green.
Use pagination controls to navigate through all messages in large threads.
Back to All Threads