POSTGRESQL DATABASE INTERVIEW QUESTIONS

What is the purpose of the RANK() function in PostgreSQL?

How does the DENSE_RANK() function differ from the RANK() function in PostgreSQL?

Can you explain how the ROW_NUMBER() function works in PostgreSQL?

What is the difference between RANK(), DENSE_RANK(), and ROW_NUMBER() in PostgreSQL?

How would you use RANK() in PostgreSQL to rank students by their scores within each class?

What happens if there are ties in the values being ranked by the RANK() function in PostgreSQL?

How can you combine the use of RANK() and PARTITION BY in PostgreSQL to rank salespersons by their sales within each region?

How would you handle ranking in PostgreSQL when there are multiple criteria for ranking, such as ranking employees by department and then by performance score?

What is a use case for using NTILE() in PostgreSQL, and how does it differ from RANK()?

Describe a scenario where RANK(), DENSE_RANK(), and ROW_NUMBER() would return different results in PostgreSQL and explain why.