October 3, 2014 at 9:13 am
Thanks, was trying to add something and not thinking.
Changed to 130
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
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.
Viewing 3 posts - 46 through 47 (of 47 total)
You must be logged in to reply to this topic. Login to reply