阅读背景:

SQL Fetch Query执行以在本地和天蓝色的服务器上减慢速度

来源:互联网 
SELECT Users.Id,
       Users.IsActive,
       Users.Risk,
       Users.Name,
       Users.EmployeeID,
       Users.OrganizationId,
       Users.Username,
       Users.IsUser,
       Users.WFID,
       Organizations.Name AS orgName,
       (SELECT MAX(UserTestGroups.ModifiedOn)
        FROM UsersInSchedules
        LEFT JOIN UserTestGroups ON UsersInSchedules.Id = UserTestGroups.UserInScheduleID
        WHERE Users.Id = UsersInSchedules.UserID) AS LastTest
FROM Users
LEFT JOIN Organizations ON Users.OrganizationID = Organizations.Id
WHERE Users.isUser = '0'
      AND Users.IsDeleted = '0'
ORDER BY Users.Name ASC
OFFSET 15 ROWS FETCH NEXT 15 ROWS ONLY
SELECT Users.Id,
       Users.IsActive,
       



你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: