October 5, 2014 at 11:35 pm
I the question you mention sales value of 150 for customerID 5. But in the answer you are inserting 25 for customerID. If anyone can help here?
October 9, 2014 at 2:47 am
Ed Wagner (10/1/2014)
Are you guys serious? The example of what the results should be was just that - an example. If the example was 1, 2, 3, 3 then either RANK or DENSE_RANK would work. The example of 1, 2, 3, 3, 4 was to show that no skips were wanted in the result set, just like the requirements stated right before the example. The example was to give clarification to the stated question.
FYI, Steve already changed the question & added 5th record.
Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant
Viewing 2 posts - 46 through 47 (of 47 total)
You must be logged in to reply to this topic. Login to reply