try:select count(0) FROM (SELECT [id], title FROM news WHERE news_type='1')aselect * from
(select rownum as [count],a.* from (SELECT [id], title FROM news WHERE news_type='1' )a ) b
where b.[count]>0 and b.[count]<=10
(select rownum as [count],a.* from (SELECT [id], title FROM news WHERE news_type='1' )a ) b
where b.[count]>0 and b.[count]<=10
,a.* from (SELECT id, title FROM news WHERE news_type='1' ) a)a --加上别名
where [count]>0 and [count]<=10 --count是保留关键字,加上[]