Menu
Home / CSE / PHP - CS :: Discussion

Discussion :: PHP - CS

  1. What does the DESC keyword do in the following query?

    SELECT *
    FROM MY_TABLE
    WHERE ID > 0
    ORDER BY ID, NAME DESC"
    2. A.

     It causes the dataset returned by the query to be sorted in descending order
    B.

     It causes rows with the same ID to be sorted by NAME in ascending order
    C.

     It causes rows with the same ID to be sorted by NAME in descending order
    D.

     It causes rows to be sorted by NAME first and then by ID
    E.

     It causes the result set to include a description of the NAME field

    View Answer

    Workspace

    View Answer

    Answer : Option C

    Explanation :

    Explanation Not Provided

Write your comments here:

Be The First To Comment