Hi Santha,

I think this will help you ,

Begin
With ProjectTable As
(Select *, Row_Number()Over(Order By ProjectID) as RowNum from Project)
Select * from ProjectTable Where RowNum = 9
End

Here the 'ProjectTable' is the Common Table Expression used to hold the result set of the project table temporarily.
You can use any table instead of project table.

Tell me How usefull was it

Thanks,
L.Srikumar