Resolved: How can we have result from below query (Count(First_name) in ascending / descending order ?
2 answers ( 1 marked as helpful)
Super learner
This user is a Super Learner. To become a Super Learner, you need to reach Level 8.
Hi Shekhar Tanwar,
Refer to screen shot below - addition of ORDER BY.
This was taken a little further into the GROUP BY video @ 4:56 or thereabouts.
Hope this helps.
Kind regards,
Kev T.
Hi Shekhar and Kev!
Thanks for reaching out.
@: Kev
Thanks for sharing this piece of information with the Community!
@: Shekhar
You need to use the ORDER BY clause with the keyword ASC or DESC according to the case of sorting.
Note: If you do not specify the order with a keyword, the default one is ASC - ascending way.
Hope this helps.
Best,
Tsvetelin