sqlÎÊÌâ - MS-SQL Server / »ù´¡Àà

SQL code:

RID BID DID
1 1 101
1 1 102
1 1 103
1 1 104
1 1 105
1 1 106
1 1 107
1 2 108
1 2 109
1 2 110
1 2 111
1 2 112
1 2 113
1 2 114


²éѯ rid=1 bid=1 ÏÂdidµÄÊýÁ¿Îª7£¬rid=1 bid=2 ÏÂdidµÄÊýÁ¿Îª7£¬
ÏëÐγɽá¹û¼¯£º
SQL code:

RID BID num
1 1 7
1 2 7


sql´úÂë

---

SQL code:
--------------------SQL ServerÊý¾Ý¸ñʽ»¯¹¤¾ß-------------------
---------------------------------------------------------------
-- DESIGNER :happycell188(ϲϲ)
-- QQ :584738179
-- Development Tool :Microsoft Visual C++ 6.0 C Language
-- FUNCTION :CONVERT DATA TO T-SQL
---------------------------------------------------------------
-- Microsoft SQL Server 2005
-- Developer Edition on Microsoft Windows XP [°æ±¾ 5.1.2600]
---------------------------------------------------------------
---------------------------------------------------------------

use test
go
if object_id('test.dbo.tb') is not null drop table tb
-- ´´½¨Êý¾Ý±í
create table tb
(
RID int,
BID int,
DID int
)
go
--²åÈ