What is the purpose of ORDER BY clause in MySQL? How is it different from GROUP BY clause?
ORDER BY clause is used to sort a particular field in either ascending order or descending order. ORDER BY is used to order while GROUP BY is used to sort.