Assume a salary of 10k. What will be the dense rank and column value?
💡 Model Answer
The DENSE_RANK() window function assigns a rank to each distinct value in the order specified, without gaps. If you have a salary column and you filter for a salary of 10,000, DENSE_RANK() will return the rank of that salary among all distinct salaries. For example, if the distinct salaries in descending order are 15k, 12k, 10k, 9k, then 10k gets a dense rank of 3. The "column value" refers to the rank column you would add to your SELECT list, e.g., SELECT salary, DENSE_RANK() OVER (ORDER BY salary DESC) AS rank_col FROM employees; The rank_col for rows with salary 10k would be 3.
This answer was generated by AI for study purposes. Use it as a starting point — personalize it with your own experience.
🎤 Get questions like this answered in real-time
Assisting AI listens to your interview, captures questions live, and gives you instant AI-powered answers on a discreet on-screen overlay.
Get Assisting AI — Starts at ₹500