Article View: cn.bbs.comp.database
Article #9745Re: һ����ѯ�������
From: ���
Date: Tue, 08 Jul 2003 10:50
Date: Tue, 08 Jul 2003 10:50
29 lines
1439 bytes
1439 bytes
������˵��̫�����
�廪һgg����
oracle:
select a.c_unionId, b.c_unionIdSum
from
(
select id, id || ', ' || lead(id, 1) over (order by id) c_unionId
from t_test
) a,
(
select id, sum(amount) c_unionIdSum
from t_test
group by id
) b
where a.id = b.id and
a.id = 1
�� �� pat (98CS~~����~~����Alec) �Ĵ������ᵽ: ��
: ʹ��һ��SQL�����������
: �� �� chary (����) �Ĵ������ᵽ: ��
: : ��������¼
: : id amount
: : 1 3
: : 2 4
: : Ҫ�õ�
: : id amount
: : 1,2 7
--
[m[1;31m�� ��Դ:���Ұ��Ͽ�վ bbs.nankai.edu.cn��[FROM: 202.113.25.232][m
Technical Details
Message-ID:
<47BUJi$ZC3@bbs.nankai.edu.cn>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-08!supernews.com!newsfeed.news2me.com!newsfeed.media.kyoto-u.ac.jp!newsgate.cuhk.edu.hk!news.zixia.net!news.happynet.org!NanKaiShow Full Headers
Complete Article Headers
X-Google-Language: Chinese,GB X-Google-Thread: 101948,1bc95fce296619f8 X-Google-Attributes: gid101948,public X-Google-ArrivalTime: 2003-07-08 03:53:08 PST Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-08!supernews.com!newsfeed.news2me.com!newsfeed.media.kyoto-u.ac.jp!newsgate.cuhk.edu.hk!news.zixia.net!news.happynet.org!NanKai From: bogey.bbs@bbs.nankai.edu.cn (���) Newsgroups: cn.bbs.comp.database Subject: Re: һ����ѯ������� Date: 08 Jul 2003 10:50:17 GMT Organization: �Ұ��Ͽ�վ Message-ID: <47BUJi$ZC3@bbs.nankai.edu.cn> X-Filename: Database/M.1057661372.A Lines: 29