��һ��sql��group by��÷�

Article View: cn.bbs.comp.database

Article #137

Back to cn.bbs.comp.database Previous Next

#137

From: ·��˹��
Date: Fri, 03 Sep 2010 17:37

6 lines
1131 bytes

select column1, max(column2) from tableA group by column1
��εõ��������ֶζ�Ӧ��tableA�е�ԭʼ��¼��Ҳ���ǰ������ֶ���Ϣ�Ľ��
�ǲ���һ��Ҫ����joinԭ�?��û��������
--

[m[1;36m�� ��Դ:����ˮ˼Դ bbs.sjtu.edu.cn��[FROM: 58.34.163.109][m

Technical Details

Message-ID: <51c209$beW@bbs.sjtu.edu.cn>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!feeder2.cambriumusenet.nl!feed.tweaknews.nl!192.87.166.28.MISMATCH!tudelft.nl!txtfeed1.tudelft.nl!newsfeed.straub-nv.de!news.shec6.edu.cn!SJTU

Show Full Headers

Complete Article Headers

X-Google-Thread: 101948,967d9d4c5488451b,start
X-Google-NewGroupId: yes
X-Google-Attributes: gid4df683fd51,domainid0,public,usenet
X-Google-Language: Chinese,GB
Path: arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!feeder2.cambriumusenet.nl!feed.tweaknews.nl!192.87.166.28.MISMATCH!tudelft.nl!txtfeed1.tudelft.nl!newsfeed.straub-nv.de!news.shec6.edu.cn!SJTU
From: Enrique.bbs@bbs.sjtu.edu.cn (·��˹�������)
Newsgroups: cn.bbs.comp.database
Subject: ��һ��sql�����group by���÷�
Date: 03 Sep 2010 17:37:39 GMT
Organization: ��ˮ˼Դ
Message-ID: <51c209$beW@bbs.sjtu.edu.cn>
Mime-Version: 1.0
Content-Type: text/plain; charset="gb2312"
Content-Transfer-Encoding: 8bit
X-Filename: database/M.1283535369.A

Article View: cn.bbs.comp.database

��һ��sql�����group by���÷�

��һ��sql��group by��÷�