Affine Analytics Interview Questions | What is a RANK() function? How is it different from ROW_NUMBER()?
Question
TheDataMonk
Follow Me
About TheDataMonkGrand Master
I am the Co-Founder of The Data Monk. I have a total of 6+ years of analytics experience 3+ years at Mu Sigma 2 years at OYO 1 year and counting at The Data Monk I am an active trader and a logically sarcastic idiot :)Follow Me
Related questions
The Given Data set, Table has transitive dependencies. Explain Which Attributes are partially dependent. How will you overcome this? Explain the approach?
Write a query to Plot a Relationship between the highest followers in every country (Country Wise Highest Followers) and show which country has the highest followers and which country has the lowest one. Explain the approach?
Write a Query to Find the account with the highest number of followers in every country. Explain the approach?
Assign Rank To each Category by authentic engagement in each country and return the category with a rank less than 3. Explain the Approach?
Write a Query to check for Missing values in the given table? Explain how will you deal with the missing data for qualitative and quantitative data?
Answers ( 2 )
Rank()
Select *, Rank() Over(order by salary)as rank from employees
Row_Number()
Select *, Row_Number() Over(order by salary) as rowno from employees
Rank() function will assign same ranks to the observations who have same value(over
which it has been ordered, in this case salary) whereas Row_Number() will assign a unique Row Number
to every observation starting from 1 till the count of the rows.
Rank()
/*Suppose you have employees table consists of Salary*/
A rank function assigns values according to the salary, If the employees consist of the same salary they are assigned the same rank. On the Other hand, Row_Number() assigns values with respect to the number of rows starting from 1, irrespective of values present in salary.