Article View: cn.bbs.comp.database
Article #785Re: �ʸ�oracle����Ŀ
From: Galaxy��VOLUNTEERS��Database
Date: Tue, 04 Nov 2008 15:09
Date: Tue, 04 Nov 2008 15:09
36 lines
1998 bytes
1998 bytes
http://www.orafaq.com/wiki/Minus Minus From Oracle FAQ Jump to: navigation, search MINUS is a SQL set operation that selects elements from the first table and them removes rows that are also returned by the second SELECT statement. For example, the below query will all return rows that are in table_A, but not in table_B: SELECT * FROM table_A MINUS SELECT * FROM table_B; Additionally, if there are two identical rows in table_A, and that same row exists in table_B, BOTH rows from table_A will be removed from the result set. �� �� Boykins ( ���-���}�˹����ɽ��ˮ��}������) �Ĵ������ᵽ: ��: ��minus���ܶࡣ : ��not exists Ҳ���ԡ� : �� �� Dem �Ĵ������ᵽ: �� : : Ҫ��sql server�Ļ�not in��Ч�ʡ���������best practices���Ǿ����ġ����� : : minus MSSQLû�У�Ʈ��� -- Welcome to Database Board ��ӭ4����ݿ�� http://bbs.sjtu.edu.cn/bbsdoc?board=database [m[1;33m�� 4Դ:����ˮ˼Դ bbs.sjtu.edu.cn��[FROM: 207.46.55.31][m [1;36m�� �ı���:��Dem �� 11��04��23:09:22 �ı��ġ�[FROM: 207.46.55.31][m [1;36m�� ������:��Dem �� 11��04��23:09:35 �ı��ġ�[FROM: 207.46.55.31][m
Technical Details
Message-ID:
<4ci48F$ail@bbs.sjtu.edu.cn>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!news1.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!news.neu.edu.cn!news.shec6.edu.cn!SJTUShow Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,GB Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!news1.google.com!border1.nntp.dca.giganews.com!nntp.giganews.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: �ʸ�oracle����Ŀ Date: 04 Nov 2008 15:09:35 GMT Organization: ��ˮ˼Դ Message-ID: <4ci48F$ail@bbs.sjtu.edu.cn> Mime-Version: 1.0 Content-Type: text/plain; charset="gb2312" Content-Transfer-Encoding: 8bit X-Filename: database/M.1225811343.A Lines: 35