SQL Injection Cheat Sheet. Query Language. Analytic functions by Example. This article provides a clear, thorough concept of analytic functions and its various options by a series of simple yet concept building examples.
The article is intended for SQL coders, who for might be not be using analytic functions due to unfamiliarity with its cryptic syntax or uncertainty about its logic of operation. Often I see that people tend to reinvent the feature provided by analytic functions by native join and sub-query SQL.