tag:blogger.com,1999:blog-495177919198719500.post4804106051539468842..comments2023-12-27T20:52:29.483-08:00Comments on Microsoft Sql Server Tutorials: SKIP and TAKE ‘N’ number of records in a SQL Server Select QuerySuprotim Agarwalhttp://www.blogger.com/profile/08349831623922214390noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-495177919198719500.post-90214014390455420782011-05-20T09:38:10.054-07:002011-05-20T09:38:10.054-07:00You'd be a little better off just doing a WHER...You'd be a little better off just doing a WHERE rownum > 5 and selecting the top 5; then you don't actually have to evaluate the condition for every row.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-495177919198719500.post-90606255037398783482010-07-14T13:01:37.143-07:002010-07-14T13:01:37.143-07:00Thanks a lotThanks a lotAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-495177919198719500.post-58747226892889048002010-02-06T22:16:21.211-08:002010-02-06T22:16:21.211-08:00Thanks for that linkThanks for that linkJeffreynoreply@blogger.comtag:blogger.com,1999:blog-495177919198719500.post-38263917276342895092010-02-03T22:52:29.185-08:002010-02-03T22:52:29.185-08:00Also see how you can effectively use row_number() ...Also see how you can effectively use row_number() function for various purposes<br /><br />http://beyondrelational.com/blogs/madhivanan/archive/2007/08/27/multipurpose-row-number-function.aspx<br /><br />MadhivananUnknownhttps://www.blogger.com/profile/13241916831072779717noreply@blogger.com