agreggate

Adobe Air RSS/ATOM Aggregate Reader

Any one using any cool Air App that can either hook into Google Reader and most important add RSS/ATOM feeds? I tried ReadAir - but it didn't work well. ...

Sql Server : How to use an aggregate function like MAX in a WHERE clause.

I want get the maximum value for this record. Please help me: SELECT rest.field1 FROM mastertable AS m INNER JOIN ( SELECT t1.field1 field1, t2.field2 FROM table1 AS T1 INNER JOIN table2 AS t2 ON t2.field = t1.field WHERE t1.field3=MAX(t1.field3) -- ...

Stored Procedure in postgresql, multiple queries w/ agreggates.

I'm trying to write a store procedure that can take some input parameters (obviously), run multiple queries against those, taking the output from those and doing calculations, and from those calculations and the original queries, outputting a formatted text string like: Number of Rows for max(Z) matching condition x and y of total rows ...

CONECT BY for two tables with two JOINS

Hi, I have 3 tables: - two with hierarchical structures (like "dimensions" of recursive type of hierarchy); - one with summing data (like "facts" with X column). There are here: 1) DIM1 (ID1, PARENT2, NAME1) 2) DIM2 (ID2, PARENT2, NAME2) 3) FACTS (ID1, ID2, X) Example of DIM1 table: -- 1 0 DIM1 ---- ...