select * from ((select * ,rn=row_number() over(order by newHouseId desc) from (Select * from newHouse where 1=1)t1) ) t2 where t2.rn between 1 and 5
--缺少临时表别名 select * from (select * ,rn=row_number() over(order by newHouseId desc) from (Select * from newHouse where 1=1 ) a) as t where t.rn between 1 and 5
多了一个括号 select * from ((select * ,rn=row_number() over(order by newHouseId desc) from (Select * from newHouse where 1=1)) as t where t.rn between 1 and 5
select * from ((select * ,rn=row_number() over(order by newHouseId desc) from (Select * from newHouse where 1=1)) as t where t.rn between 1 and 5 楼上的两位大大 按照你们说的去改也不正确
弄好了 谢谢楼上两位大神select * from (select * ,rn=row_number() over(order by newHouseId desc) from (Select * from newHouse where 1=1)a) as t where t.rn between 1 and 5
select * from (select * ,rn=row_number() over(order by newHouseId desc) ID from (Select * from newHouse where 1=1)a) as t where t.rn between 1 and 5
select * from ((select * ,rn=row_number() over(order by newHouseId desc) from (Select * from newHouse where 1=1)t1)
) t2 where t2.rn between 1 and 5
select * from
(select * ,rn=row_number() over(order by newHouseId desc)
from (Select * from newHouse where 1=1 ) a)
as t where t.rn between 1 and 5
select * from ((select * ,rn=row_number() over(order by newHouseId desc) from (Select * from newHouse where 1=1))
as t where t.rn between 1 and 5
as t where t.rn between 1 and 5
楼上的两位大大 按照你们说的去改也不正确
as t where t.rn between 1 and 5
as t where t.rn between 1 and 5