Forum

Posted by Yogita, Nov. 6, 2021, 9:11 p.m.

SQL question1 and 2

What if there are multiple records with same total_sales? Shouldn't we be finding the top sales and then pass it in the where clause than just going ahead with order by and limit?
Answer

Answers

Comment
Hi Yogita, that is a great point, for almost all questions here on sqlpad, we generally assume there are no ties, will update the questions to make it clearer. Thanks for your feedback!
SQLPad user avatar

Leon (949)

Nov. 7, 2021, 12:05 p.m.