34,590
社区成员
发帖
与我相关
我的任务
分享
SELECT poco_base.*
FROM (
SELECT ROW_NUMBER() OVER(ORDER BY Exam_RowID asc) AS RowID,
Exam_ID AS ExamID,Exam_Difficulty AS Difficulty,
Exam_StuUsedCount AS StudentUsedCount,
Exam_QuestionTypeID AS QuestionTypeID,
Exam_QuestionTypeName AS QuestionTypeName,
Exam_ErrorCount AS ErrorCount
FROM dbo.T_ExamSync
WHERE (Exam_State=1)) poco_base WHERE poco_base.RowID>0 AND poco_base.RowID<=10