Forum

Posted by rak, March 6, 2022, 12:52 p.m.

Question 9

Is there another way to solve this question without a subquery??
Answer

Answers

Comment
Hey Rak,
Yes, there are many different ways to solve a question (in general), and for #9, I can think of at least 2 other ways to solve it.
e.g., 1. using a CTE or 2.using LEFT JOIN from the dates to payment table.
Leon
SQLPad user avatar

Leon (949)

March 7, 2022, 9:47 a.m.