Which databases have analytic functions like Oracle

Question

Doesn't have to be the same syntax, but same or similar functionality.

Please provide the name used for the construct and a simple example.

Answer 1

SQLServer/T-SQL has similar functionality.