Re: ��2��SQL��(with��unique)

Article View: cn.bbs.comp.database

Article #22

Back to cn.bbs.comp.database Previous Next

#22

From: Galaxy��VOLUNTEERS��Database
Date: Mon, 12 Oct 2009 03:02

21 lines
1791 bytes

����ɶ��ݿ⡣�����������һ��With��д����SQL Server�ģ����ڶ����Unique��Ora
cle�ġ�����
�� �� McWang (SJTU-X) �Ĵ������ᵽ: ��
: ���˺þû��ǲ��У�����˵���﷨�д?�����������ǰ�����ʦ��ķ����ʽд�ġ�����
: Ҫץ���ˣ����ܿ���ָ�㣬�ǳ���л��
: 1.����ǹ���with�ģ�
: with isbnAndLib(isbn,lib_name) as
: (select distinct isbn, lib_name
: from in_stock)
: select isbn from isbnAndLib��
: ����ִ��with isbnAndLib(isbn,lib_name) as
: (select distinct isbn, lib_name
: from in_stock)��Ҳ���У���isbnAndLib���������ȥ��Ҳ���С�
: .................������ʡ�ԣ�

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

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

Technical Details

Message-ID: <4iMg8Y$bKj@bbs.sjtu.edu.cn>

Path:

arc1-ca.pugleaf.net!g2news2.google.com!news1.google.com!news.glorb.com!newsgate.cuhk.edu.hk!www.shinco.com!news.shec6.edu.cn!SJTU

Show Full Headers

Complete Article Headers

X-Google-Thread: 4df683fd51,bea72abe13d6961b,start
X-Google-Attributes: gid4df683fd51,public,usenet
X-Google-NewGroupId: yes
X-Google-Language: Chinese,GB
Path: arc1-ca.pugleaf.net!g2news2.google.com!news1.google.com!news.glorb.com!newsgate.cuhk.edu.hk!www.shinco.com!news.shec6.edu.cn!SJTU
From: Dem.bbs@bbs.sjtu.edu.cn (Galaxy��VOLUNTEERS��Database)
Newsgroups: cn.bbs.comp.database
Subject: Re: �������2��SQL���(with��unique)
Date: 12 Oct 2009 03:02:26 GMT
Organization: ��ˮ˼Դ
Message-ID: <4iMg8Y$bKj@bbs.sjtu.edu.cn>
Mime-Version: 1.0
Content-Type: text/plain; charset="gb2312"
Content-Transfer-Encoding: 8bit
X-Filename: database/M.1255316386.A

Article View: cn.bbs.comp.database

Re: �������2��SQL���(with��unique)

Re: ��2��SQL��(with��unique)