select * from (select *,num=(select count(*) from tb b where b.id<a.id) from tb a) a where a.num in('3','5','8')
select tid=identity(int,1,1),* into # from tbselect col1,col2,... from # where tid in(3,5,8) --除tid外的所有列drop table #
有自增列情况: SELECT * FROM (SELECT * , (SELECT COUNT(*) AS NUM FROM LI T WHERE T.ID <= A.ID) FROM LI A) LO WHERE A.NUM IN (3,5,8) 没有自增列情况: SELECT * FROM ( SELECT ROW_NUMBER() OVER(ORDER BY GETDATE()) AS RID,* FROM LI) LO WHERE LO.RID IN (3,5,8)
select * from
(select *,num=(select count(*) from tb b where b.id<a.id) from tb a) a
where a.num in('3','5','8')
SELECT *
FROM
(SELECT * , (SELECT COUNT(*) AS NUM FROM LI T WHERE T.ID <= A.ID) FROM LI A) LO
WHERE A.NUM IN (3,5,8) 没有自增列情况:
SELECT *
FROM
(
SELECT ROW_NUMBER() OVER(ORDER BY GETDATE()) AS RID,*
FROM LI) LO
WHERE LO.RID IN (3,5,8)