Thread: Retrieve only the Nth row from a table?
View Single Post
  #5  
Old 12-19-2007, 05:08 AM
theone theone is offline
D-Web Sr.Programmer
  
Join Date: Jun 2007
Posts: 129
theone is on a distinguished road
Default Re: Retrieve only the Nth row from a table?
Hi Santha,

You can try this also,

Select *
From (Select *,(Row_Number() Over (Order By ProjectID)) As Rownum
From Project) P
Where P.Rownum = 10
Reply With Quote