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)
Tsvetelin Tsonkov
Instructor
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