Resolved: SELECT first_name FROM employees GROUP BY first name did not work properly
Hi, unfortunately after running this query I got a lost of first names of employees not in Alphabetical Order like in Your video, just random names.
There was no error however just no alph.order. Why so?
Thx,
Ana
Ups....tried again and experimented, it worked out only with the line ORDER BY first_name ASC. Strange, I assume this Mysql version just needs it.
Had the same problem and figured it out just like you did. In the initial description, he does say GROUP BY has to be used with the ORDER BY clause. But in his demo, he doesn't do it, but it works all the same. Not sure what the real problem is.
Hi Anna and Puvanan!
Thanks for reaching out.
I am glad that you have resolved your issue. We need the ORDER BY clause.
Hope this helps.
Best,
Tsvetelin
Hi Instructor,
Actually i had the same problem and after reading the comments i resolved it but there is 1 more problem i found that here 1000 rows returned but in your video its only 1275. Will you please help me out.
My this issue also has been resolved.
Thankyou.