Tags for max()
SELECT-INTO returns more than one row
Hi, I am far from new to database programming but totally new to Teradata and really struggling with stored procedures (amongst other things). I have a particular problem at the moment with a stored procedure failing with the error message "SELECT-INTO returned more than one row".
sql max() select into
MAX() and MAX() OVER (PARTITION BY ....) in the same query produces error 3504
I am trying to produce a results table with the last completed course date for each course code, as well as the last completed course code overall for each employee. Below is my query: 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', 'M91301R', 'M91301P') GROUP BY employee_number This query produces the following error: 3504 : Selected non-aggregate values must be part of the associated group
aggregate functions max()