CREATE TABLE [T_PassPlace] (
[F_Id] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[F_Place] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[F_Order] [int] NULL
) ON [PRIMARY]
GO
select * from
(select a.F_id F_id,a.F_Order aOrder,b.F_Order bOrder from
(select F_id ,F_Order from T_PassPlace where F_Place = 'd') a ,
(select F_id ,F_Order from T_PassPlace where F_Place = 'h') b
where a.F_id = b.F_id) c ,T_PassPlace
where c.F_id = T_PassPlace.F_id and T_PassPlace.F_Order between c.aOrder and c.bOrder
结果
placeorder id
d
4
1
e
5
1
f
6
1
g
7
1
h
8
2
d
1
2
e
2
2
h
3
2
|