over 4 years ago
Sorting the result using Order By clause:
ORDER BY clause is used to sort the data fetched using select statement either in ascending order or in descending. By default data fetched is sorted in ascending order.
Select columnname(s) from tablename ORDER BY columnname [ ASC | DESC ];
SELECT City FROM Employee WHERE Name = 'Max' ORDER BY City ASC;
It will return all City of those employee whose name is Max and City will sort in Ascending order.
SELECT City FROM Employee WHERE Name = 'Max' ORDER BY City DESC;
Similarly it will also return city but in descending order.
Starting with Chrome version 45, NPAPI is no longer supported for Google Chrome. For more information, see Chrome and NPAPI (blog.chromium.org).
Firefox and Microsoft Internet Explorer are recommended browsers for websites using java applets.
Chrome Version Support
Are you sure, you want to delete this comment?
© copyright 2017 FindNerd.com. All rights reserved.
Sign up using