🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: cn.bbs.comp.database
Article #1375

Re: �������SQL�������⣡лл

#1375
From: ������ݿ�
Date: Tue, 21 Aug 2007 09:36
18 lines
1394 bytes
select column1, column2, count(column3) from table group by column1, column2


�� �� loveappleJ (loveapple) �Ĵ������ᵽ: ��
: column1   column2   column3
:   A          A         ada
:   A          A         fsdf
:   A          A         qw
:   A          B         vc
:   A          B         fd
:   B          B         fds
: ��εõ�:
: column1   column2    COUNT
:   A          A         3
: .................������ʡ�ԣ�
--

�� ��Դ:����ˮ˼Դ bbs.sjtu.edu.cn��[FROM: 222.68.182.226]
Technical Details
Message-ID: <4VZI04$cSb@bbs.sjtu.edu.cn>
Path: arc1-ca.pugleaf.net!g2news2.google.com!news4.google.com!feeder1-2.proxad.net!proxad.net!feeder1-1.proxad.net!club-internet.fr!feedme-small.clubint.net!194.25.134.62.MISMATCH!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!news.cn99.com!bbsnews.sdu.edu.cn!SJTUBBS

Show Full Headers
Complete Article Headers
X-Google-Thread: 101948,c460820079d337f6,start
X-Google-Attributes: gid101948,public,usenet
X-Google-Language: ENGLISH,GB
Path: arc1-ca.pugleaf.net!g2news2.google.com!news4.google.com!feeder1-2.proxad.net!proxad.net!feeder1-1.proxad.net!club-internet.fr!feedme-small.clubint.net!194.25.134.62.MISMATCH!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!news.cn99.com!bbsnews.sdu.edu.cn!SJTUBBS
From: alovestory.bbs@bbs.sjtu.edu.cn (������ݿ�)
Newsgroups: cn.bbs.comp.database
Subject: Re: �������SQL�������⣡лл
Date: 21 Aug 2007 09:36:38 GMT
Organization: ��ˮ˼Դ
Message-ID: <4VZI04$cSb@bbs.sjtu.edu.cn>
Mime-Version: 1.0
Content-Type: text/plain; charset="gb2312"
Content-Transfer-Encoding: 8bit
X-Filename: database/M.1187688964.A
Lines: 18