- 4733 Views
- 3 replies
- 2 kudos
Resolved! Are window functions more performant than self joins?
I have a table with data for each month end and want to know the LEAD and LAG data points either side of each month. For example:SELECT month_date, LEAD(month_date) OVER (PARTITION BY id ORDER BY month_date) next_month_date, LAG(month_date) OVER (PA...
- 4733 Views
- 3 replies
- 2 kudos
Latest Reply
- 2 kudos
Hi @Matthew Elsham​ Thank you for posting your question in our community! We are happy to assist you.To help us provide you with the most accurate information, could you please take a moment to review the responses and select the one that best answer...
- 2 kudos