SQL multiple column ordering

Question

SQL multiple column ordering

How might I sort by numerous sections in SQL and in various directions? column1 would be arranged to descend and column2 ascending.

sql-order-by sql

4 years ago by Amit8z4mc

2 Answers

Login / Signup to Answer the Question.

Login Signup

**espadacoder11** · Answer 1 · 2021-05-20T09:31:26



ORDER BY column1 DESC, column2

This sorts everything by column1 (descending) first, and then by column2 (ascending, which is the default) whenever the column1 fields for two or more rows are equal.

**kshitijrana14** · Answer 2 · 2021-05-21T14:52:27

You can use multiple ordering on multiple condition,

ORDER BY 

     (CASE 

        WHEN @AlphabetBy = 2  THEN [Drug Name]

      END) ASC,

    CASE 

        WHEN @TopBy = 1  THEN [Rx Count]

        WHEN @TopBy = 2  THEN [Cost]

        WHEN @TopBy = 3  THEN [Revenue]

    END DESC

C TUTORIAL

C PROGRAMS

INTERVIEW TESTS

EXECUTE CODE

C++ TUTORIAL

C++ PROGRAMS

INTERVIEW TESTS

EXECUTE CODE

PYTHON TUTORIAL

PYTHON HOW TOS

INTERVIEW TESTS

EXECUTE CODE

JAVA TUTORIAL

JAVA CODE EXAMPLES

SPRING TUTORIAL

MORE IN JAVA

COMPUTER ARCHITECTURE

COMPUTER NETWORK

OPERATING SYSTEM

DBMS & SQL

PL/SQL

MongoDB

EXECUTE SQL

ANDROID DEVELOPMENT

GO LANGUAGE

LINUX

DOCKER

HTML TAGS (A to Z)

CSS REFERENCES

SASS/SCSS

KOTLIN

GAME DEVELOPMENT

PHP

GIT GUIDE

JAVASCRIPT

ADVANCED DSA

SQL multiple column ordering

2 Answers

Login / Signup to Answer the Question.