Are you familiar with SQL window functions?
💡 Model Answer
Window functions perform calculations across a set of rows that are related to the current row, without collapsing the result set into a single row. They are defined with an OVER clause that specifies the partitioning and ordering. Common examples include ROW_NUMBER, RANK, DENSE_RANK, NTILE, LAG, LEAD, and aggregate functions like SUM, AVG, MIN, MAX used as window functions. They are useful for tasks such as ranking, running totals, moving averages, and comparing a row to its predecessor or successor.
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 — invisible to screen sharing.
Get Assisting AI — Starts at ₹500