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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy