1 . How will you find IPHONE users in your campus? 2. Difference between rank and dense rank?

Question

Accepted Answer

Answering questions related to finding iPhone users on campus and the difference between rank and dense rank.

To find iPhone users on campus, one can conduct a survey or use location-based services to track devices connected to the campus Wi-Fi network.
Rank and dense rank are used in SQL to assign a unique rank to each row in a result set based on a specified column. The difference is that dense rank does not leave gaps in the ranking sequence.
For example, if there are three students with the same GPA, their ranks would be 1, 2, and 2 using rank, but 1, 2, and 3 using dense rank.

Popular interview questions of Analyst