Article View: cn.bbs.comp.database
Article #65Re: ������sql�
From: Galaxy��VOLUNTEERS��Database
Date: Thu, 06 Aug 2009 08:51
Date: Thu, 06 Aug 2009 08:51
21 lines
1877 bytes
1877 bytes
��ʵ�ղŻ������һ������а���ķ�����unionһ����������ֵΪ0�ı?Ȼ��ȡMax ����������̫����а���ˣ����������join�ȽϺá����� �� �� Dem (Galaxy��VOLUNTEERS��Database) �Ĵ������ᵽ: �� : create table #temp : drop #temp : ����Ҳ���а������� : ��ô���ö���ѯ�� : ������һ�£��ѵ�һ������������Щ���Ƶ�link�� : How to display 0 in conditional [group by] report in Count() SQL Query : http://lichao.net/eblog/how-to-display-0-in-conditional-group-by-report-in-co : unt-sql-query-200808164.html : �����и�query�����������Ҹղ�˵����left join�������nvl�� : SELECT Region.Region_Name, NVL(SubTotal.Total,0) As SalesTotal : .................������ʡ�ԣ� -- Welcome to Database Board ��ӭ������ݿ�� http://bbs.sjtu.edu.cn/bbsdoc?board=database [m[1;33m�� ��Դ:����ˮ˼Դ bbs.sjtu.edu.cn��[FROM: 207.46.55.28][m
Technical Details
Message-ID:
<4hIYVh$bif@bbs.sjtu.edu.cn>Path:
arc1-ca.pugleaf.net!g2news2.google.com!news2.google.com!news.glorb.com!news2.glorb.com!news.neu.edu.cn!news.shec6.edu.cn!SJTUShow Full Headers
Complete Article Headers
X-Google-Thread: 4df683fd51,adb32091b8365bec,start X-Google-Attributes: gid4df683fd51,public,usenet X-Google-NewGroupId: yes X-Google-Language: Chinese,GB Path: arc1-ca.pugleaf.net!g2news2.google.com!news2.google.com!news.glorb.com!news2.glorb.com!news.neu.edu.cn!news.shec6.edu.cn!SJTU From: Dem.bbs@bbs.sjtu.edu.cn (Galaxy��VOLUNTEERS��Database) Newsgroups: cn.bbs.comp.database Subject: Re: ������sqlд�� Date: 06 Aug 2009 08:51:32 GMT Organization: ��ˮ˼Դ Message-ID: <4hIYVh$bif@bbs.sjtu.edu.cn> Mime-Version: 1.0 Content-Type: text/plain; charset="gb2312" Content-Transfer-Encoding: 8bit X-Filename: database/M.1249548283.A