The exec sp_executesql N 'SELECT
[Project1]. [PMIATTRIBUTEID] AS [PMIATTRIBUTEID],
[Project1]. [SUPPLIERMATERIAL] AS [SUPPLIERMATERIAL],
[Project1]. [CREATEDATE] AS [CREATEDATE]
The FROM (SELECT
[Extent1]. [PMIATTRIBUTEID] AS [PMIATTRIBUTEID],
[Extent1]. [SUPPLIERMATERIAL] AS [SUPPLIERMATERIAL],
[Extent1]. [CREATEDATE] AS [CREATEDATE]
The FROM [dbo] [T_Info_MES_PMIAttribute] AS [Extent1]
) AS [Project1]
The ORDER BY [Project1]. [CREATEDATE] DESC
OFFSET 30 ROWS FETCH NEXT 30 ROWS ONLY '

The exec sp_executesql N 'SELECT
[Project1]. [PMIATTRIBUTEID] AS [PMIATTRIBUTEID],
[Project1]. [SUPPLIERMATERIAL] AS [SUPPLIERMATERIAL],
[Project1]. [CREATEDATE] AS [CREATEDATE]
The FROM (SELECT
[Extent1]. [PMIATTRIBUTEID] AS [PMIATTRIBUTEID],
[Extent1]. [SUPPLIERMATERIAL] AS [SUPPLIERMATERIAL],
[Extent1]. [CREATEDATE] AS [CREATEDATE]
The FROM [dbo] [T_Info_MES_PMIAttribute] AS [Extent1]
) AS [Project1]
The ORDER BY [Project1]. [CREATEDATE] DESC
OFFSET 60 ROWS FETCH NEXT 30 ROWS ONLY '

CodePudding user response:

Order to be able to return to determine the value of the the CREATEDATE you are the same is not as expected returns the result