prefix question
It seems to me that whether I use m.dept_no or dept_no following 'order by' and 'group by' both have the same result. So my question here is that do I have to specify the m. or d. prefix in codes? Thanks.
1 answers ( 0 marked as helpful)
Hi Angela!
Thanks for reaching out.
It depends on the task. If in this case the result set is the same, then you can use both.
Hope this helps.
Best,
Tsvetelin