数据库:MS SQL 2000:
drop table mytest
go
create table mytest
(
snint,
codevarchar(8),
ins_novarchar(6),
)
go
insert mytest values(1, '01', 'A')
insert mytest values(1, '01', 'B')
insert mytest values(2, '02', 'A')
insert mytest values(2, '02', 'D')
insert mytest values(3, '01', 'A')
insert mytest values(3, '01', 'B')
insert mytest values(4, '03', 'A')
insert mytest values(4, '03', 'B')
insert mytest values(4, '03', 'C')
insert mytest values(5, '03', 'B')
insert mytest values(5, '03', 'C')
insert mytest values(6, '02', 'A')
insert mytest values(6, '02', 'C')
insert mytest values(6, '02', 'D')
go
select * from mytest
go
sn codeins_no
-----------------
101A
101B
202A
202D
403A
403B
403C
503B
503C
602A
602C
602D
能否用一个查询语句得到?先谢了
|