order by

    0

    0

    lucycodes42

    SQL public snippets

    In this code, the ORDER BY clause displays the results in alphabetical order, based on the value of the $&[USER_INPUT:1] variable, which is the value of the first input field. The same clause then displays the results in alphabetical order, based on the value of the $&[USER_INPUT:2: DESC] variable, which is the value of the second input field.

    Shortcut: s_o

    ORDER BY `$` DESC
    Codiga Logo
    Codiga Hub
    • Rulesets
    • Playground
    • Snippets
    • Cookbooks
    soc-2 icon

    We are SOC-2 Compliance Certified

    G2 high performer medal

    Codiga – All rights reserved 2022.