3 ms·
that works for top-1 but breaks completely if you want to extend it to top-2
by nightpool 3y ago
that works for top-1 but breaks completely if you want to extend it to top-2
- ttfkam 3y agoThe example was asking for top 1. Yes, you are correct that you'd have to switch up to a window function to handle top-n+1. Do you believe these cases are common enough to warrant discarding the tools and training available to SQL? Are you also certain that PRQL doesn't have corner cases where SQL is more concise and/or easier to understand?