SELECT *
FROM (select ROW_NUMBER()over(order by newsid)as A,
*from(select NewsID,Title from dbo.COM_News)as t
)as tt
where A between 10 and 50
FROM (select ROW_NUMBER()over(order by newsid)as A,
*from(select NewsID,Title from dbo.COM_News)as t
)as tt
where A between 10 and 50
FROM (select ROW_NUMBER()over(order by newsid)as A,
*from(select NewsID,Title from dbo.COM_News)as t
)as tt
where A between 10 and 50
FROM (select ROW_NUMBER()over(order by newsid)as A,
NewsID,Title from dbo.COM_News
)as tt
where A between 10 and 50
select NewsID,Title from dbo.COM_Newsas
where between 10 and 50
(select ROW_NUMBER()over(order by newsid)as A,NewsID,Title from dbo.COM_Newsas) a
where a.A between 10 and 50
FROM (select ROW_NUMBER()over(order by newsid)as A,
*from(select NewsID,Title from dbo.COM_News)as t
)as tt
FROM (select ROW_NUMBER()over(order by newsid)as A,*
from(select NewsID,Title from dbo.COM_News)as t
)as tt
where A between 10 and 50
就是
SELECT t.*
FROM (select ROW_NUMBER()over(order by newsid)as A,
*from(select NewsID,Title from dbo.COM_News)as t
)as tt
where A between 10 and 50tt.*可以 里面的T为啥就不可以了呢