February 26, 2025 at 12:00 am
Comments posted to this topic are about the item The Rank Window II
February 26, 2025 at 5:49 am
I'm afraid the given answer is not correct. using the SalesDate as part of the SELECT will deliver 10 unique rows. Removing the date then does indeed provide 8 unique rows.
February 26, 2025 at 5:55 am
I'm afraid the given answer is not correct. using the SalesDate as part of the SELECT will deliver 10 unique rows. Removing the date then does indeed provide 8 unique rows.
My Bad, didn't read the question properly - still haven't had my first cup of coffee this morning...
February 26, 2025 at 8:29 am
The DDL for the table was missing the [total] column.
February 26, 2025 at 8:34 am
The DDL for the table was missing the [total] column.
February 26, 2025 at 6:54 pm
ddl corrected
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply