sql ÓïÃû - MS-SQL Server / »ù´¡Àà

tb


create ta(card varchar(10),rq varchar(2),sktime varchar(5))
go
insert into ta(card,rq,sktime)
select '123456','01','00:01'
union
select '123456','01','00:02'
union
select '123456','01','00:03'
union
select '123456','02','01:01'
union
select '123456','02','02:01'
union
select '123456','04','00:01'
union
select '234567','01','00:01'
union
select '234567','01','00:02'

go

Òª²é³öµÄ½á¹û£º

card '01' '02' '03' '04'
123456 00:01 01:01 00:01
123456 00:02 02:01
123456 00:03
234567 00:01
234567 00:02

---

×ݺá³öÀ´ºÃ¶àNULLÖµ¡£