SpiceQA
Questions
Tags
Users
Badges
aggregate-functions
249 Questions
Newest
Active
Unanswered
Frequent
More
Score
View
Card
Compact
SQL: How to select a column-value based on an aggregate min/max value in a window frame (including preceding rows)
user_1066006
0
•
asked Feb 12, 2021
2
1
75
aggregate-functions
window-functions
postgresql
sql
PostgreSQL: Aggregating combinations of names in list
user_408060
0
•
asked Jan 30, 2021
2
2
51
aggregate-functions
join
postgresql
sql
database
UPDATE with jsonb_set() only affects one object in nested array
user_5252581
0
•
asked Jan 19, 2021
2
1
443
jsonb
aggregate-functions
sql-update
postgresql
sql
How can we display first row and last row of given table using rownum without using union clause
user_14983447
0
•
asked Jan 11, 2021
2
1
125
aggregate-functions
oracle
sql
PostgresQL window function over blocks of continuous IDs
user_2160256
0
•
asked Jan 8, 2021
2
2
331
aggregate-functions
window-functions
postgresql
I want to to find a way to get my appropriate result in 1 mysql query
user_8779111
0
•
asked Jan 6, 2021
4
2
109
aggregate-functions
mysql
Adding second join to query is making values duplicate
user_1496707
0
•
asked Jan 5, 2021
2
0
58
aggregate-functions
duplicates
group-by
mysql
sql
Scala aggregate function vs. Spark RDD aggregate function
user_4653212
0
•
asked Dec 31, 2020
3
1
176
apache-spark
aggregate-functions
lazy-evaluation
scala
Eliminate null results from case query - no null values in source
user_14197711
0
•
asked Dec 28, 2020
1
1
57
string-agg
aggregate-functions
pivot
case
sql-server
Using join and group with sum
user_14884927
0
•
asked Dec 24, 2020
2
2
50
aggregate-functions
having-clause
inner-join
mysql
sql
Prev
Prev
9
10
11
(current)
12
13
Next
Next
Hot Questions