What is the use of DESC in SQL?

What is the use of DESC in SQL?

What is the use of DESC in SQL?

View Answers

November 18, 2010 at 6:20 PM

Hi,

DESC has two purposes. It is used to describe a schema as well as to retrieve rows from table in descending order. Explanation : The query

SELECT * FROM EMP ORDER BY ENAME DESC

will display the output sorted on ENAME in descending order.

Thanks.









Related Tutorials/Questions & Answers:
What is the use of DESC in SQL?
ModuleNotFoundError: No module named 'sqlt'
Advertisements
ModuleNotFoundError: No module named 'sqlu'
ModuleNotFoundError: No module named 'sqlx'
ModuleNotFoundError: No module named 'sqly'
ModuleNotFoundError: No module named 'sqlf'
ModuleNotFoundError: No module named 'sqlf'
Maven dependency for org.umlg - sqlg-mysql-dialect version 2.1.6 is released. Learn to use sqlg-mysql-dialect version 2.1.6 in Maven based Java projects
Maven dependency for org.umlg - sqlg-mysql-dialect version 2.1.5 is released. Learn to use sqlg-mysql-dialect version 2.1.5 in Maven based Java projects
Maven dependency for org.umlg - sqlg-mysql-dialect version 2.1.4 is released. Learn to use sqlg-mysql-dialect version 2.1.4 in Maven based Java projects
Maven dependency for org.umlg - sqlg-mysql-dialect version 2.1.3 is released. Learn to use sqlg-mysql-dialect version 2.1.3 in Maven based Java projects
Maven dependency for org.umlg - sqlg-mysql-dialect version 2.1.2 is released. Learn to use sqlg-mysql-dialect version 2.1.2 in Maven based Java projects
Maven dependency for org.umlg - sqlg-mysql-dialect version 2.1.1-1 is released. Learn to use sqlg-mysql-dialect version 2.1.1-1 in Maven based Java projects
Maven dependency for org.umlg - sqlg-mysql-dialect version 2.1.1 is released. Learn to use sqlg-mysql-dialect version 2.1.1 in Maven based Java projects
Maven dependency for org.umlg - sqlg-mysql-dialect version 2.1.0 is released. Learn to use sqlg-mysql-dialect version 2.1.0 in Maven based Java projects
Maven dependency for org.umlg - sqlg-mysql-dialect version 2.0.2 is released. Learn to use sqlg-mysql-dialect version 2.0.2 in Maven based Java projects
SQLl query count and group by
ModuleNotFoundError: No module named 'sqlg'
ModuleNotFoundError: No module named 'desc'
ModuleNotFoundError: No module named 'desc-pro'
ModuleNotFoundError: No module named 'MLZ-DESC'
ModuleNotFoundError: No module named 'desc-pro'
ModuleNotFoundError: No module named 'falcon-sqla'
ModuleNotFoundError: No module named 'nefertari_sqla'
ModuleNotFoundError: No module named 'pyramid_sqla'
ModuleNotFoundError: No module named 'sqla_declarative'
ModuleNotFoundError: No module named 'sqla-filters'
ModuleNotFoundError: No module named 'sqla_helpers'
ModuleNotFoundError: No module named 'sqla-hierarchy'
ModuleNotFoundError: No module named 'sqla-inspect'
ModuleNotFoundError: No module named 'sqla_declarative'
ModuleNotFoundError: No module named 'sqla-filters'
ModuleNotFoundError: No module named 'sqla_helpers'
ModuleNotFoundError: No module named 'sqla-hierarchy'
ModuleNotFoundError: No module named 'sqla-inspect'
ModuleNotFoundError: No module named 'sqla_mixins'
ModuleNotFoundError: No module named 'sqla-models'
ModuleNotFoundError: No module named 'sqla-paranoid'
ModuleNotFoundError: No module named 'sqla-softdelete'
ModuleNotFoundError: No module named 'sqla-taskq'
ModuleNotFoundError: No module named 'sqla-views'
ModuleNotFoundError: No module named 'sqla-wrapper'
ModuleNotFoundError: No module named 'falcon-sqla'
Maven Repository/Dependency: org.umlg | sqlg-mysql-dialect
ModuleNotFoundError: No module named 'flask_sqla_debug'
ModuleNotFoundError: No module named 'pyramid_debugtoolbar_api_sqla'
ModuleNotFoundError: No module named 'sqla-filters-json'
ModuleNotFoundError: No module named 'sqla-filters-yaml'
ModuleNotFoundError: No module named 'sqla-filters-json'
ModuleNotFoundError: No module named 'sqla-filters-yaml'

Ads