window-functions

365 Questions
Newest Active Unanswered Frequent
Score
View
Card Compact
How to count distinct based on a condition over a window aggregation in PySpark?
user_13327390
•
2
2
552
distinct-values pyspark apache-spark window-functions python
calculate avg(value) for last 10 records postgresql
user_98977220
•
2
4
414
window-functions postgresql average sql
Spark "first" Window function is taking much longer than "last"
user_5296180
•
7
1
511
pyspark apache-spark-sql apache-spark window-functions performance
How to find the nth largest salary by department using SQLite
user_109695480
•
1
1
55
correlated-subquery window-functions count sqlite sql
SUM distinct inside window function
user_93882460
•
1
1
107
aggregate-functions window-functions distinct postgresql
Pyspark window function to calculate number of transits between stops
user_106122860
•
2
1
104
pyspark apache-spark-sql apache-spark window-functions python
Extracting rows with a consecutive pattern that exceeds a threshold
user_105764300
•
2
1
22
correlated-subquery window-functions mysql
In hive window, what would happen if the value of CURRENT ROW is smaller than that of UNBOUNDED PRECEDING
user_167783250
•
2
1
139
hiveql hive hadoop window-functions sql
Count Distinct Window Function with Groupby
user_125612410
•
2
3
376
snowflake-cloud-data-platform window-functions sql
If a product was ordered earlier
user_106106310
•
2
1
27
amazon-redshift self-join window-functions exists sql
Hot Questions