我有一个包含大学课程信息的MS SQL数据库表。这是中继器内部的自定义查询,带有当前在Kentico中使用的自定义查询(这不是我写的)。
SELECT 'ALL' AS Course,
'All' AS CourseProgram,
'1' as ID
UNION
SELECT DISTINCT SUBJ_CODE AS COURSE
SUBJ_DESC AS CourseProgram,
NULL AS ID
ORDER BY ID DESC, Course
到目前为止,课程是按课程标题排序的,每个部分都是单独列出的…
courseName
我正在尝试解释编写时间线代码和文档类代码之间的区别,到目前为止我已经做到了:
Timeline code:
- doesn't require a package and class declaration
Document Class code:
- requires a package and class declaration
Timeline code:
- starts working on the top-most line
Document Class Code:
- starts working from the constructor function
Tim
我正在尝试生成一个结果表,其中包含每个课程代码的最后完成课程日期,以及每个员工整体的最后完成课程代码。下面是我的问题:
SELECT employee_number,
MAX(course_completion_date)
OVER (PARTITION BY course_code) AS max_course_date,
MAX(course_completion_date) AS max_date
FROM employee_course_completion
WHERE course_code IN ('M910303'