SpiceQA
Questions
Tags
Users
Badges
group-by
1387 Questions
Newest
Active
Unanswered
Frequent
More
Score
View
Card
Compact
Left join with count() and show matches separately within table
user_17985425
0
•
asked Feb 5, 2022
1
1
28
qgis
left-join
count
group-by
sqlite
GROUP BY Works with Select columns not in GROUP BY
user_13098681
0
•
asked Feb 1, 2022
2
2
211
aggregates
select
group-by
sqlite
database
SQL query to partition rows into groups where lag (difference between rows) is greater than some value
user_13174372
0
•
asked Feb 1, 2022
1
1
91
partition
trino
lag
group-by
sql
keep first row after calculating difference between rows with dplyr::lag
user_6674698
0
•
asked Jan 31, 2022
2
1
152
dplyr
lag
r
group-by
Understanding groupby after repartition in pyspark
user_8089695
0
•
asked Jan 31, 2022
1
0
101
pyspark
apache-spark-sql
apache-spark
group-by
SQL - delete duplicates with null values WITHOUT row_number
user_13769660
0
•
asked Jan 30, 2022
3
2
161
sql-delete
duplicates
group-by
null
sqlite
How to create a column that measures the number of items that exits in another string column?
user_12659227
0
•
asked Jan 30, 2022
2
2
50
pandas-groupby
pandas
dataframe
group-by
python
Efficient way subtract a row with previous row seperated by group with Pandas
user_6446053
0
•
asked Jan 30, 2022
1
2
46
pandas
group-by
python
Can repeating query be saved?
user_48778
0
•
asked Jan 29, 2022
2
2
37
count
distinct
group-by
sqlite
python
How to partial column using GROUP BY CUBE in sql (Error in SQL statement: UnsupportedOperationException:)
user_18062952
0
•
asked Jan 29, 2022
1
1
43
pyspark
group-by
sql
Prev
Prev
40
41
42
(current)
43
44
Next
Next
Hot Questions