Why do you need to place columns you create yourself (for example select 1 as "number") after HAVING and not WHERE in MySQL?

And are there any downsides instead of doing WHERE 1 (writing the whole definition instead of a column name)?

7 Answers
7

Leave a Reply

Your email address will not be published. Required fields are marked *