Re: �ʸ�oracle��Ŀ

Article View: cn.bbs.comp.database

Article #781

Back to cn.bbs.comp.database Previous Next

#781

From: Galaxy��VOLUNTEERS
Date: Mon, 03 Nov 2008 12:16

22 lines
1799 bytes

��SQL Server�Ļ���Ҫ��UNION ALL������Ϊ��Ҫgroup by id,name������ֱ�ӱ�distin
ct�ˣ��޷��ø÷���������

Ҫ��SQL Server�Ļ�������inner join������ղų�����һ���ƺ�Ч���
��exist��in��Ч����

���˼�index�벻������ĸ�õİ취�ˡ�����

�� �� OracleIOg (Oracle) �Ĵ������ᵽ: ��: 
    * ��math_student ( ID, name ) 
: ��english_student ( ID, name )
: һ���˿���ͬʱѡmath��english
: ��SQL��������ͬʱѡmath��english,��ID,Name 
: �������뷨�ǰ����ű�union�� groupby id Ȼ��ѡcount=2��  ��û�и��Ч�ķ����� 


--
Welcome to Database Board
��ӭ������ݿ��
http://bbs.sjtu.edu.cn/bbsdoc?board=database

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

Technical Details

Message-ID: <4chA8P$bKf@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!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!feeder.erje.net!newsfeed.straub-nv.de!news.shec6.edu.cn!SJTU

Show Full Headers

Complete Article Headers

X-Google-Thread: 101948,91b768bc3716f97f,start
X-Google-Attributes: gid101948,domainid0,public,usenet
X-Google-Language: Chinese,GB
Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!news1.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!feeder.erje.net!newsfeed.straub-nv.de!news.shec6.edu.cn!SJTU
From: Dem.bbs@bbs.sjtu.edu.cn (Galaxy��VOLUNTEERS)
Newsgroups: cn.bbs.comp.database
Subject: Re: �ʸ�oracle����Ŀ
Date: 03 Nov 2008 12:16:38 GMT
Organization: ��ˮ˼Դ
Message-ID: <4chA8P$bKf@bbs.sjtu.edu.cn>
Mime-Version: 1.0
Content-Type: text/plain; charset="gb2312"
Content-Transfer-Encoding: 8bit
X-Filename: database/M.1225714585.A
Lines: 22

Article View: cn.bbs.comp.database

Re: �ʸ�oracle����Ŀ

Re: �ʸ�oracle��Ŀ