Skip to main content

Posts

Showing posts from September, 2017

Window functions in SQL Server

Two guys were quarreling. I interfered to solve the problem. Though I knew Robert was right, I decided to be very polite to James and make him understand he was wrong. I tried. But, he was shouting at me and told "Prove me then!". In order to do that, I created a table which contains Robert De Niro movies. I showed him the table and asked him to count. He said, "What if the table has thousands of rows. Will you ask me to sit and count? You count and tell me. I am too busy". Point! I should not have asked him to do that. What should I do now to show the result? I have to show the director names and the number of movies directed by them. Thinking about this, I was walking in a vegetable market and saw this vegetable vendor. Thanks to her. I have implemented the idea borrowed from her. I showed this result to James. I explained him, "See, Brian De Palma has directed Robert De Niro only 3 times but Martin Scorsese 9 times"....