From the monthly archives: August 2011

Difference between RANK and ROW_NUMBER in Teradata

By On August 8, 2011 · Leave a Comment · In Teradata

In Teradata , OLAP window functions play an important role while handling complex SQL requirements. There are various WINDOW functions available in Teradata. However two of the ‘tricky’ OLAP Window functions available in Teradata are : RANK and ROW_NUMBER. To know more about ROW_NUMBER in Teradata read this post. So what is the difference between ROW_NUMBER and RANK in Teradata ? The function RANK in teradata resembles very much to rank we have in real life. We tend to give ranks to entities on the basis of values in some columns. However ROW_NUMBER in Teradata is used to generate SEQUENCE number etc. Let us take an example . In this we have a Table Student which has Student Name and Marks obtained by a Student in three Subjects. Continue reading

Check Top YouTube Videos via YouTube Charts

By On August 5, 2011 · 1 Comment · In Internet

YouTube is definitely the first option of web users when it comes to online videos watching. Generally people search for videos for Watching it on YouTube and some help from related searches in YouTube. However if you want to watch most viewed videos of this week or most liked videos of all time , then simple search won’t help. Do you know about YouTube Charts ? YouTube Charts list down videos in various categories like Education, Entertainment, Music, Sports etc in various order like Most Liked YouTube Videos , Most Subscribed YouTube Videos , Most Viewed Videos etc in different time interval. Time interval can be Today , This Week , This Month or All Time. The best part about YouTube Charts is it lets you know what is currently popular on YouTube and what others are watching and liking. So even if you don’t know about some popular videos , you can view the top videos easily in the list. Continue reading | 1 Comment

Set your Twitter account name in your settings to use the TwitterBar Section.

Switch to our mobile site