Alex Rivera | Logout

Questions tagged aggregate-functions

25 questions

Sort by: Newest Votes Active
11
votes
4
answers

SQL random aggregate

sql aggregate-functions
asked 2012-11-18T14:19:04.913
8
votes
2
answers

Oracle User defined aggregate function for varray of varchar

oracle-database oracle11g aggregate-functions varray
asked 2012-09-02T15:34:39.657
47
votes
2
answers

date_trunc 5 minute interval in PostgreSQL

sql postgresql datetime aggregate-functions
asked 2012-08-28T19:05:14.083
135
votes
24
answers

LISTAGG in Oracle to return distinct values

sql oracle-database aggregate-functions listagg
asked 2012-07-16T19:04:43.957
16
votes
2
answers

MySql Select, Count(*) and SubQueries in Users<>Comments relations

mysql sql subquery aggregate-functions
asked 2012-04-05T04:05:13.113
11
votes
3
answers

Create array in SELECT

sql postgresql aggregate aggregate-functions postgresql-9.1
asked 2012-03-20T22:39:09.937
17
votes
1
answers

Postgres window function and group by exception

sql postgresql aggregate-functions window-functions
asked 2012-01-13T01:44:50.243
11
votes
2
answers

PostgreSQL aggregate or window function to return just the last value

sql postgresql aggregate-functions
asked 2011-11-30T02:55:04.283
15
votes
4
answers

Nesting Aggregate Functions - SQL

sql postgresql aggregate-functions
asked 2011-11-15T18:47:17.880
13
votes
2
answers

How to combine aggregates within a group with aggregates across groups within SSRS

reporting-services aggregate-functions
asked 2011-11-11T11:37:34.313
57
votes
4
answers

mysql count group by having

mysql sql group-by aggregate-functions
asked 2011-10-22T05:08:26.633
13
votes
3
answers

Intersection of multiple arrays in PostgreSQL

sql arrays postgresql aggregate-functions intersection
asked 2011-08-11T02:44:49.597
50
votes
6
answers

How to SUM and SUBTRACT using SQL?

mysql sql aggregate-functions
asked 2011-07-16T03:23:56.997
32
votes
7
answers

Is it possible to use Aggregate function in a Select statment without using Group By clause?

sql sql-server sql-server-2005 group-by aggregate-functions
asked 2011-06-24T11:38:15.643
234
votes
8
answers

The SQL OVER() clause - when and why is it useful?

sql sql-server aggregate-functions clause
asked 2011-06-02T18:45:05.640
68
votes
6
answers

Do all columns in a SELECT list have to appear in a GROUP BY clause

sql select group-by aggregate-functions
asked 2011-05-13T00:45:37.707
10
votes
2
answers

User-defined aggregate functions with multiple input columns in PostgreSQL

sql postgresql aggregate-functions
asked 2011-04-15T08:03:43.853
20
votes
1
answers

Oracle / SQL - Count number of occurrences of values in a single column

sql oracle-database group-by aggregate-functions
asked 2011-01-18T22:32:54.977
9
votes
3
answers

The most useful User-Defined Aggregate Functions

sql aggregate-functions
asked 2010-12-12T12:59:49.373
29
votes
6
answers

Custom aggregate function (concat) in SQL Server

sql sql-server-2005 sql-server-2008 aggregate-functions aggregation
asked 2010-12-07T08:33:26.400
19
votes
4
answers

Multiple aggregate functions in one SQL query from the same table using different conditions

sql sql-server t-sql aggregate-functions
asked 2010-04-16T16:52:22.470
11
votes
5
answers

Multiple SUM using LINQ

c# linq aggregate-functions
asked 2009-11-09T22:05:39.520
123
votes
8
answers

MySQL "Group By" and "Order By"

mysql sql group-by sql-order-by aggregate-functions
asked 2009-06-30T22:40:38.463
24
votes
4
answers

Extra Fields with SQL MIN() & GROUP BY

sql mysql aggregate-functions
asked 2009-04-06T20:22:17.523
34
votes
5
answers

MySQL: Select N rows, but with only unique values in one column

sql mysql unique aggregate-functions min
asked 2008-10-10T10:11:46.983