Tag archive for ‘aggregate’

How to convert Oracle aggregate functions, which contain PARTITION BY and ORDER BY clauses

Posted by admin on Feb 26, 2009 • (0)

In Oracle, you can write a SELECT statement with aggregate functions (like MAX, MIN or AVG) over a partitioned query result set and specify how data are ordered within a partition. Such queries have the following format:
SELECT column_list,
Aggr_fun(column_name) OVER (PARTITION BY column_name ORDER BY column_name)
AS alias_name
FROM table_name;

SQL Server allows selecting data using aggregate functions with [...]

1