how to get the results from below query using between

See more:

SQL-Server

Hi,


I written the query

SELECT ROW_NUMBER() OVER (ORDER BY Count(*) DESC) AS [Row_Number],t.Column1,c.Column2,count(*) as Counts  from Table1 as c,Table2 as t where t.column3 Like c.cloumn2  and Column5=1 and t.column2!='' group by c.Column2,t.column1

am getting the results with column Row_Number as Auto Increment but now i want to use the Row_Number Column as between below query

<pre lang="sql">SELECT ROW_NUMBER() OVER (ORDER BY Count(*) DESC) AS [Row_Number],t.Column1,c.Column2,count(*) as Counts  from Table1 as c,Table2 as t where t.column3 Like c.cloumn2  and Column5=1 and Row_Number between 7 and 12 and t.column2!=&#39;&#39; group by c.Column2,t.column1</pre>

but Row_Number is showing error like not a valid cloumn,please tell me modifications to work with between