I need to select rows

Question

Consider i have thousand rows and i need to fetch 500 to 600 rows in that what should the query to it .Kindly help me out of this.I tried offest fetch next but it doesn't work in sql server .

Jaimin Shethiya · Answer

Hello Rajesh, can you please check the below link for https://www.c-sharpcorner.com/UploadFile/ff2f08/offset-and-fetch-in-sql-server-2012/ Thanks

Sourav Mukherjee · Answer

Which version of SQL Server are you using? Are you able to parse your query? Would be able to post the error msg? Typically the syntax goes like this - SELECT [OrderTrackingID] ,[SalesOrderID] ,[CarrierTrackingNumber] ,[TrackingEventID] ,[EventDetails] ,[EventDateTime] FROM [AdventureWorks2016CTP3].[Sales].[OrderTracking] ORDER BY [OrderTrackingID] ASC OFFSET 500 ROWS FETCH NEXT 100 ROWS ONLY

Amit Kumar · Answer

Hi, You want 100 record between 500to 600. Am I right? use below query. SELECT column -names FROM table - name ORDER BY column -names OFFSET 500 ROWS FETCH NEXT 100 ROWS ONLY

Gowtham Ramar · Answer

Hi Rajesh Just Refer the Url. Are you using ms-sql server 2008 fetch and offset not working above version it's support. https://www.mssqltips.com/sqlservertip/2362/overview-of-offset-and-fetch-feature-of-sql-server-2012/

Sonu Gupta · Answer

Hi, Try this - SELECT * FROM ( SELECT ROW_NUMBER() OVER(ORDER BY YourColumns) NUM, * FROM YOURTABLE ) A WHERE NUM >500 AND NUM

Mageshwaran R · Answer

Hi, try this code: select top 500 * from TB_TEST percentage vise: select top 50 percent * from TB_TEST

I need to select rows

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (6)