Use of ORDER BY DESC In MSSQL Database Server Tutorial Example
Run microsoft sql server management studio query editor or any client tools you like then copy & paste the below code to use order by desc by sql command or statement in MSSQL Database Server Tutorial Example
-- Northwind SELECT LastName, Country, Region FROM Employees WHERE Region IS NOT NULL AND Country NOT LIKE '%UK%' ORDER BY LastName DESC -- "DESC" descending sort order -- "ASC" ascending order & it is default
Make sure that you have "Northwind" sample database available. -- is comment in MSSQL -- in fact it is comment in Oracle and MySQL as well
No comments:
Post a Comment
leave your comments here..