If you want to show the result in ascending order then :-
SELECT * FROM Persons WHERE Age >= 25 GROUP BY first_name ASC
If you want to show the result in descending order then :-
SELECT * FROM Persons WHERE Age >= 25 GROUP BY first_name DESC
By default it is ascendeng . if we use like GROUP BY first_name then it sorts in ascending order.
0 comments:
Post a Comment