User john

2 votes

1 answer

454 views

Star schema dimension table design [closed]

asked Apr 24, 2017 at 22:55

1 vote

1 answer

274 views

How do I make Postgres use an index when using IN or ANY?

asked Nov 12, 2019 at 19:39

1 vote

1 answer

316 views

How to force Redshift/Postgres to aggregate nth_value?

asked Jul 10, 2018 at 4:43

0 votes

1 answer

517 views

How can I write a window function using something like row_number to increment only on discrete values?

asked Mar 4, 2019 at 20:59

0 votes

1 answer

2k views

Having issue with window function COUNT counting duplicates

asked Mar 21, 2019 at 18:22

0 votes

2 answers

830 views

How do I find a list of customers that have not placed an order in the past 1 year?

asked Jul 23, 2019 at 22:15

0 votes

2 answers

117 views

What's the fastest way to find the first 2 purchases for every customer in Redshift? [duplicate]

asked Jun 28, 2018 at 8:39

-1 votes

4 answers

183 views

Is there a fast way to find records that were created OR updated within a date range?

asked Nov 8, 2017 at 19:28

Stack Exchange Network

8 Questions

Star schema dimension table design [closed]

How do I make Postgres use an index when using IN or ANY?

How to force Redshift/Postgres to aggregate nth_value?

How can I write a window function using something like row_number to increment only on discrete values?

Having issue with window function COUNT counting duplicates

How do I find a list of customers that have not placed an order in the past 1 year?

What's the fastest way to find the first 2 purchases for every customer in Redshift? [duplicate]

Is there a fast way to find records that were created OR updated within a date range?