I find that window functions are one of the least used aspects of modern SQL, despite them being incredibly useful. I've used them in T-SQL [1] and PL/SQL [2],

I find that window functions are one of the least used aspects of modern SQL, despite them being incredibly useful. I've used them in T-SQL [1] and PL/SQL [2], as well (MySQL does not do window functions). If you're doing lots of SQL work, get very familiar with the OVER clause. It's a lifesaver. [1]: http://msdn.microsoft.com/en-us/library/ms189461.aspx http://msdn.microsoft.com/en-us/library/ms189461.aspx [2]: http://www.java2s.com/Tutorial/Oracle/0320__Analytical-Functions/0580__Window-Functions.htm http://www.java2s.com/Tutorial/Oracle/0320__Analytical-Funct...