SpiceQA
Questions
Tags
Users
Badges
window-functions
365 Questions
Newest
Active
Unanswered
Frequent
More
Score
View
Card
Compact
SQLite Window functions
user_3165737
0
•
asked Mar 9, 2022
1
3
269
max
window-functions
min
common-table-expression
sqlite
How to check if a group has three consecutive values in a column?
user_7119501
0
•
asked Mar 9, 2022
2
4
123
gaps-and-islands
window-functions
mysql
sql
Is it possible to output table ordered by group and limited per group?
user_13616474
0
•
asked Mar 9, 2022
1
1
27
window-functions
common-table-expression
sql-order-by
sqlite
How to find the champion with the highest number of selections in match in SQLlite
user_17302436
0
•
asked Mar 8, 2022
1
2
38
window-functions
count
group-by
sqlite
sql
Having an issue with updating a rank column
user_16762652
0
•
asked Mar 1, 2022
2
1
52
mariadb
window-functions
sql-update
mysql
How to calculate time difference in a sql window partition using condition
user_9808764
0
•
asked Feb 24, 2022
1
0
52
apache-spark-sql
window-functions
sql
SQL - Get the average of distinct values on each row of view
user_9418143
0
•
asked Feb 22, 2022
2
2
293
window-functions
distinct
sql-server
average
sql
Last unique entries above current row in Spark
user_4176951
0
•
asked Feb 14, 2022
2
1
62
apache-spark
window-functions
scala
Writing a SQL request with a CTE and counting its rows
user_5596875
0
•
asked Feb 9, 2022
3
3
168
window-functions
common-table-expression
join
sqlite
sql
How to do forward fill as a PL/PGSQL function
user_11318930
0
•
asked Feb 4, 2022
2
1
194
plpgsql
window-functions
postgresql
sql
Prev
Prev
6
7
8
(current)
9
10
Next
Next
Hot Questions