Post reply

Ranking

  • October 3, 2014 at 9:13 am

    #1750010

    Thanks, was trying to add something and not thinking.

    Changed to 130

  • October 5, 2014 at 11:35 pm

    #1750215

    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

    #1751184

    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 3 posts - 46 through 47 (of 47 total)

You must be logged in to reply to this topic. Login to reply